View: PA_EXPENDITURE_TYPES_RES_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_EXPENDITURE_TYPES_RES_V

View Text

SELECT EXPT.EXPENDITURE_TYPE
, EXPT.DESCRIPTION
, EXPT.EXPENDITURE_CATEGORY
, EXPT.REVENUE_CATEGORY_CODE
, DECODE ( EXPSL1.EXPENDITURE_TYPE
, NULL
, 'N'
, 'Y')
, EXPT.UNIT_OF_MEASURE
, 'Y'
FROM PA_EXPENDITURE_TYPES EXPT
, PA_EXPEND_TYP_SYS_LINKS EXPSL1
WHERE EXPSL1.EXPENDITURE_TYPE (+) = EXPT.EXPENDITURE_TYPE
AND EXPSL1.SYSTEM_LINKAGE_FUNCTION (+) = 'ST'
AND DECODE (PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, EXPT.START_DATE_ACTIVE
, TRUNC(SYSDATE)) BETWEEN EXPT.START_DATE_ACTIVE
AND NVL(EXPT.END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns