View: PA_PROJ_COST_EXPEND_VIEW

Product:	PA - Projects
Description:	Transactions for Project Costing projects, including quantities and cost amounts.
Implementation/DBA Data:	APPS.PA_PROJ_COST_EXPEND_VIEW

View Text

SELECT EI.EXPENDITURE_ITEM_ID
, T.PROJECT_ID
, PER.FULL_NAME
, NVL(PER.EMPLOYEE_NUMBER
, PER.NPW_NUMBER)
, E.INCURRED_BY_PERSON_ID
, VEND.VENDOR_ID
, VEND.SEGMENT1
, VEND.VENDOR_NAME
, NVL(PER.FULL_NAME
, VEND.VENDOR_NAME)
, NVL(NVL(PER.EMPLOYEE_NUMBER
, PER.NPW_NUMBER)
, VEND.SEGMENT1)
, E.INCURRED_BY_ORGANIZATION_ID
, ORGTL1.NAME
, EI.COST_JOB_ID
, JOB.NAME
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'USG'
, EI.NON_LABOR_RESOURCE||'-'||ORGTL2.NAME
, 'VI'
, NULL
, 'PJ'
, NULL
, 'WIP'
, NULL
, 'INV'
, NULL
, 'BTC'
, NULL
, JOB.NAME)
, EI.EXPENDITURE_TYPE
, T.TASK_ID
, T.TASK_NUMBER
, EI.EXPENDITURE_ITEM_DATE
, EI.QUANTITY
, LK.MEANING
, EI.RAW_COST
, EI.BURDEN_COST
, EI.COST_DISTRIBUTED_FLAG
, EI.NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID
, ORGTL2.NAME
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_EXPENDITURES_ALL E
, PA_EXPENDITURE_TYPES ET
, PA_LOOKUPS LK
, PA_TASKS T
, PO_VENDORS VEND
, PER_JOBS JOB
, HR_ORG_UNITS_NO_JOIN ORG1
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL1
, HR_ORG_UNITS_NO_JOIN ORG2
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL2
, PER_PEOPLE_F PER
WHERE T.TASK_ID = EI.TASK_ID
AND EI.EXPENDITURE_ID = E.EXPENDITURE_ID
AND EI.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND E.INCURRED_BY_PERSON_ID = PER.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+)
AND PER.EFFECTIVE_END_DATE (+)
AND EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID (+)
AND CDL.LINE_NUM (+) = 1
AND CDL.SYSTEM_REFERENCE1 = VEND.VENDOR_ID (+)
AND E.INCURRED_BY_ORGANIZATION_ID = ORG1.ORGANIZATION_ID(+)
AND ORG1.ORGANIZATION_ID = ORGTL1.ORGANIZATION_ID(+)
AND DECODE(ORGTL1.ORGANIZATION_ID
, NULL
, '1'
, ORGTL1.LANGUAGE) = DECODE(ORGTL1.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND EI.ORGANIZATION_ID = ORG2.ORGANIZATION_ID (+)
AND ORG2.ORGANIZATION_ID = ORGTL2.ORGANIZATION_ID(+)
AND DECODE(ORGTL2.ORGANIZATION_ID
, NULL
, '1'
, ORGTL2.LANGUAGE) = DECODE(ORGTL2.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND NVL( EI.UNIT_OF_MEASURE
, ET.UNIT_OF_MEASURE) = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'UNIT'
AND EI.JOB_ID = JOB.JOB_ID (+)

Columns