View: PJM_PROJECT_EXPEND_V

Product:	PJM - Project Manufacturing
Description:	Project expenditures for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_EXPEND_V

View Text

SELECT T.PROJECT_ID
, EI.TASK_ID
, T.TASK_NUMBER
, EI.EXPENDITURE_ITEM_ID
, EI.EXPENDITURE_TYPE
, ET.EXPENDITURE_CATEGORY
, ET.REVENUE_CATEGORY_CODE
, EO.NAME
, EI.EXPENDITURE_ITEM_DATE
, EI.QUANTITY
, UOM.MEANING
, TO_CHAR( NVL(EI.BURDEN_COST
, 0)
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.ACCT_CURRENCY_CODE
, 40 ) )
, TO_CHAR( EI.ACCRUED_REVENUE
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.ACCT_CURRENCY_CODE
, 40 ) )
, TO_CHAR( EI.BILL_AMOUNT
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.ACCT_CURRENCY_CODE
, 40 ) )
, EI.NON_LABOR_RESOURCE
, NLO.NAME
, X.INCURRED_BY_PERSON_ID
, EMP.FULL_NAME
, EMP.EMPLOYEE_NUMBER
, EI.JOB_ID
, J.NAME
, X.VENDOR_ID
, SUPP.VENDOR_NAME
FROM HR_ALL_ORGANIZATION_UNITS_TL EO
, HR_ALL_ORGANIZATION_UNITS_TL NLO
, PA_LOOKUPS UOM
, PA_EXPENDITURES_ALL X
, PA_EXPENDITURE_TYPES ET
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_TASKS T
, PA_IMPLEMENTATIONS IMP
, PER_ALL_PEOPLE_F EMP
, PER_JOBS J
, PO_VENDORS SUPP
WHERE EI.TASK_ID = T.TASK_ID
AND EI.EXPENDITURE_ID = X.EXPENDITURE_ID
AND EO.ORGANIZATION_ID = NVL( EI.OVERRIDE_TO_ORGANIZATION_ID
, X.INCURRED_BY_ORGANIZATION_ID)
AND EO.LANGUAGE = USERENV('LANG')
AND NLO.ORGANIZATION_ID (+) = EI.ORGANIZATION_ID
AND NLO.LANGUAGE (+) = USERENV('LANG')
AND EI.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND UOM.LOOKUP_TYPE = 'UNIT'
AND UOM.LOOKUP_CODE = ET.UNIT_OF_MEASURE
AND ( NVL(EI.ORG_ID
, -99) = NVL(IMP.ORG_ID
, -99) OR NVL(PA_EXPENDITURE_INQUIRY.GET_MODE
, 'X') <> 'CROSS-PROJECT' )
AND EI.JOB_ID = J.JOB_ID (+)
AND X.INCURRED_BY_PERSON_ID = EMP.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN NVL(EMP.EFFECTIVE_START_DATE
, SYSDATE - 1)
AND NVL(EMP.EFFECTIVE_END_DATE
, SYSDATE + 1)
AND X.VENDOR_ID = SUPP.VENDOR_ID (+)

Columns