1. Tables and Views for Project Management
  2. PJC_LD_COST_ELEMENT_TYPES_V

PJC_LD_COST_ELEMENT_TYPES_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

ELEMENT_TYPE_ID

ELEMENTCODE

ELEMENT_NAME

Query

SQL_Statement

SELECT

b.element_type_id,

b.base_element_name ElementCode,

b.element_name

FROM

pay_element_types_vl b

WHERE EXISTS(select 1 from pjc_alloc_runs_all ldelementpeo where ldelementpeo.ld_orig_transaction_reference is not null and ldelementpeo.ld_element_type_id = b.element_type_id)

and trunc(sysdate) BETWEEN trunc(b.effective_start_date) AND trunc(b.effective_end_date)

order by

b.element_name