View: PA_XLA_COST_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_XLA_COST_V

View Text

SELECT EXP.EXPENDITURE_ITEM_ID
, PP.NAME || ' (' || PP.SEGMENT1 ||')'
, PT.TASK_NAME || ' (' || PT.TASK_NUMBER || ')'
, AWD.AWARD_SHORT_NAME || DECODE(AWD.AWARD_SHORT_NAME
, NULL
, NULL
, ' (') || AWD.AWARD_NUMBER || DECODE(AWD.AWARD_SHORT_NAME
, NULL
, NULL
, ')')
, EXP.EXPENDITURE_TYPE
, SYS.MEANING
, ET.EXPENDITURE_CATEGORY
, EXP.EXPENDITURE_ITEM_DATE
, HR.NAME
, EXP.NON_LABOR_RESOURCE
FROM PA_EXPENDITURE_ITEMS_ALL EXP
, PA_EXPENDITURES_ALL PEX
, PA_TASKS PT
, PA_PROJECTS_ALL PP
, GMS_AWARD_DISTRIBUTIONS ADL
, GMS_AWARDS_ALL AWD
, HR_ALL_ORGANIZATION_UNITS HR
, PA_EXPENDITURE_TYPES ET
, PA_SYSTEM_LINKAGES SYS
WHERE EXP.PROJECT_ID = PP.PROJECT_ID
AND EXP.PROJECT_ID = PT.PROJECT_ID
AND EXP.TASK_ID = PT.TASK_ID
AND EXP.EXPENDITURE_ID = PEX.EXPENDITURE_ID
AND HR.ORGANIZATION_ID = NVL(EXP.OVERRIDE_TO_ORGANIZATION_ID
, INCURRED_BY_ORGANIZATION_ID)
AND EXP.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND EXP.SYSTEM_LINKAGE_FUNCTION = SYS.FUNCTION
AND EXP.EXPENDITURE_ITEM_ID = ADL.EXPENDITURE_ITEM_ID (+)
AND ADL.DOCUMENT_TYPE(+) = 'EXP'
AND ADL.AWARD_ID = AWD.AWARD_ID (+)
AND ADL.ADL_LINE_NUM(+) = 1
AND ADL.ADL_STATUS(+) = 'A'

Columns