VIEW: APPS.CST_PROJ_EXP_TYPES_VAL_V

Source

View Text - Preformatted

SELECT pet.expenditure_type ,pet.expenditure_type_id ,pet.description ,decode(psys.system_linkage_function,'INV',1,'BTC',2,3) ,psys.start_date_active ,psys.end_date_active ,pet.start_date_active ,pet.end_date_active ,pet.unit_of_measure FROM pa_expenditure_types pet, pa_expend_typ_sys_links psys WHERE pet.expenditure_type = psys.expenditure_type AND psys.system_linkage_function in ('INV','WIP','BTC','ST') union SELECT pet.expenditure_type ,pet.expenditure_type_id ,pet.description ,decode(psys.system_linkage_function,'BTC',5,'WIP',4) ,psys.start_date_active ,psys.end_date_active ,pet.start_date_active ,pet.end_date_active ,pet.unit_of_measure FROM pa_expenditure_types pet, pa_expend_typ_sys_links psys WHERE pet.expenditure_type = psys.expenditure_type AND psys.system_linkage_function in ('WIP','BTC')

View Text - HTML Formatted

SELECT PET.EXPENDITURE_TYPE
, PET.EXPENDITURE_TYPE_ID
, PET.DESCRIPTION
, DECODE(PSYS.SYSTEM_LINKAGE_FUNCTION
, 'INV'
, 1
, 'BTC'
, 2
, 3)
, PSYS.START_DATE_ACTIVE
, PSYS.END_DATE_ACTIVE
, PET.START_DATE_ACTIVE
, PET.END_DATE_ACTIVE
, PET.UNIT_OF_MEASURE
FROM PA_EXPENDITURE_TYPES PET
, PA_EXPEND_TYP_SYS_LINKS PSYS
WHERE PET.EXPENDITURE_TYPE = PSYS.EXPENDITURE_TYPE
AND PSYS.SYSTEM_LINKAGE_FUNCTION IN ('INV'
, 'WIP'
, 'BTC'
, 'ST') UNION SELECT PET.EXPENDITURE_TYPE
, PET.EXPENDITURE_TYPE_ID
, PET.DESCRIPTION
, DECODE(PSYS.SYSTEM_LINKAGE_FUNCTION
, 'BTC'
, 5
, 'WIP'
, 4)
, PSYS.START_DATE_ACTIVE
, PSYS.END_DATE_ACTIVE
, PET.START_DATE_ACTIVE
, PET.END_DATE_ACTIVE
, PET.UNIT_OF_MEASURE
FROM PA_EXPENDITURE_TYPES PET
, PA_EXPEND_TYP_SYS_LINKS PSYS
WHERE PET.EXPENDITURE_TYPE = PSYS.EXPENDITURE_TYPE
AND PSYS.SYSTEM_LINKAGE_FUNCTION IN ('WIP'
, 'BTC')