VIEW: APPS.PJM_PROJECT_EXPEND_V

Source

View Text - Preformatted

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 , EI.PROJFUNC_CURRENCY_CODE , TO_CHAR( NVL(EI.BURDEN_COST , 0) , FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJFUNC_CURRENCY_CODE , 40 ) ) , TO_CHAR( EI.ACCRUED_REVENUE , FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJFUNC_CURRENCY_CODE , 40 ) ) , TO_CHAR( EI.BILL_AMOUNT , FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJFUNC_CURRENCY_CODE , 40 ) ) , EI.PROJECT_CURRENCY_CODE , TO_CHAR(NVL(EI.PROJECT_BURDENED_COST , 0) , FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJECT_CURRENCY_CODE , 40 ) ) , TO_CHAR( EI.PROJECT_RAW_REVENUE , FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJECT_CURRENCY_CODE , 40 ) ) , TO_CHAR( EI.PROJECT_BILL_AMOUNT , FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJECT_CURRENCY_CODE , 40 ) ) , EI.BILL_TRANS_CURRENCY_CODE , TO_CHAR( EI.BILL_TRANS_BILL_AMOUNT , FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.BILL_TRANS_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_ALL 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 (+) AND X.ORG_ID = IMP.ORG_ID

View Text - HTML Formatted

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
, EI.PROJFUNC_CURRENCY_CODE
, TO_CHAR( NVL(EI.BURDEN_COST
, 0)
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJFUNC_CURRENCY_CODE
, 40 ) )
, TO_CHAR( EI.ACCRUED_REVENUE
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJFUNC_CURRENCY_CODE
, 40 ) )
, TO_CHAR( EI.BILL_AMOUNT
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJFUNC_CURRENCY_CODE
, 40 ) )
, EI.PROJECT_CURRENCY_CODE
, TO_CHAR(NVL(EI.PROJECT_BURDENED_COST
, 0)
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJECT_CURRENCY_CODE
, 40 ) )
, TO_CHAR( EI.PROJECT_RAW_REVENUE
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJECT_CURRENCY_CODE
, 40 ) )
, TO_CHAR( EI.PROJECT_BILL_AMOUNT
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.PROJECT_CURRENCY_CODE
, 40 ) )
, EI.BILL_TRANS_CURRENCY_CODE
, TO_CHAR( EI.BILL_TRANS_BILL_AMOUNT
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( EI.BILL_TRANS_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_ALL 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 (+)
AND X.ORG_ID = IMP.ORG_ID