eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CST_PROJ_EXP_TYPES_VAL_V

Product:	BOM - Bills of Material
Description:	Expenditure types associated with cost elements
Implementation/DBA Data:	APPS.CST_PROJ_EXP_TYPES_VAL_V

View Text

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')

Columns

Name
EXPENDITURE_TYPE
EXPENDITURE_TYPE_ID
DESCRIPTION
COST_ELEMENT_ID
SYS_LINK_START_DATE
SYS_LINK_END_DATE
EXP_TYPE_START_DATE
EXP_TYPE_END_DATE
UNIT_OF_MEASURE