View: PA_XLA_CROSSCHARGE_V

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

View Text

SELECT EXP.EXPENDITURE_ITEM_ID
, PP.NAME || ' (' || PP.SEGMENT1 ||')'
, PT.TASK_NAME || ' (' || PT.TASK_NUMBER || ')'
, EXP.EXPENDITURE_TYPE
, SYS.MEANING
, ET.EXPENDITURE_CATEGORY
, EXP.EXPENDITURE_ITEM_DATE
, EXP_ORG.NAME
, PRVDR_ORG.NAME
, RCVR_ORG.NAME
, PL.MEANING
FROM PA_EXPENDITURE_ITEMS_ALL EXP
, PA_EXPENDITURES_ALL PEX
, PA_TASKS PT
, PA_PROJECTS_ALL PP
, HR_ALL_ORGANIZATION_UNITS EXP_ORG
, HR_ALL_ORGANIZATION_UNITS PRVDR_ORG
, HR_ALL_ORGANIZATION_UNITS RCVR_ORG
, PA_EXPENDITURE_TYPES ET
, PA_SYSTEM_LINKAGES SYS
, PA_LOOKUPS PL
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 EXP_ORG.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 PRVDR_ORG.ORGANIZATION_ID = EXP.CC_PRVDR_ORGANIZATION_ID
AND RCVR_ORG.ORGANIZATION_ID = EXP.CC_RECVR_ORGANIZATION_ID
AND EXP.CC_CROSS_CHARGE_CODE = PL.LOOKUP_CODE
AND PL.LOOKUP_TYPE = 'CC_CROSS_CHARGE_CODE'

Columns