View: PA_LABOR_EXPENDITURES_VIEW

Product:	PA - Projects
Description:	View of detail labor transactions for employee activity and utilization. PA_LABOR_EXPENDITURES_VIEW shows detail labor transactions for employee activity and utilization
Implementation/DBA Data:	APPS.PA_LABOR_EXPENDITURES_VIEW

View Text

SELECT P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, P.PROJECT_TYPE
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, PER.PERSON_ID
, NVL(PER.EMPLOYEE_NUMBER
, PER.NPW_NUMBER ) EMPLOYEE_NUMBER
, PER.FULL_NAME
, JOB.JOB_ID
, JOB.NAME
, ORG.ORGANIZATION_ID
, ORG.NAME
, E.EXPENDITURE_ENDING_DATE
, E.ORIG_USER_EXP_TXN_REFERENCE
, EI.EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, NVL(EI.QUANTITY
, 0)
, 0)
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'OT'
, NVL(EI.QUANTITY
, 0)
, 0)
, DECODE(EI.BILLABLE_FLAG
, 'Y'
, NVL(EI.QUANTITY
, 0)
, 0)
, DECODE(EI.BILLABLE_FLAG
, 'N'
, NVL(EI.QUANTITY
, 0)
, 0)
, EI.RAW_COST
, EI.BURDEN_COST
, NVL(EI.ADJUSTED_REVENUE
, EI.RAW_REVENUE)
, EI.ACCRUED_REVENUE
, EI.BILLABLE_FLAG
, EI.DENOM_CURRENCY_CODE
, EI.DENOM_RAW_COST
, EI.DENOM_BURDENED_COST
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RATE_DATE
, EI.ACCT_RATE_TYPE
, EI.ACCT_EXCHANGE_RATE
, EI.ACCT_RAW_COST
, EI.ACCT_BURDENED_COST
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_RATE_TYPE
, EI.PROJECT_EXCHANGE_RATE
, E.TRANSFER_STATUS_CODE
, E.WF_STATUS_CODE
, E.ORIG_EXP_TXN_REFERENCE1
, E.ORIG_EXP_TXN_REFERENCE2
, E.ORIG_EXP_TXN_REFERENCE3
, E.USER_BATCH_NAME
, E.OVERRIDING_APPROVER_PERSON_ID
FROM PA_PROJECTS_ALL P
, PA_TASKS T
, PA_EXPENDITURES_ALL E
, PA_EXPENDITURE_ITEMS_ALL EI
, PER_PEOPLE_F PER
, PER_JOBS JOB
, HR_ORGANIZATION_UNITS ORG
WHERE P.PROJECT_ID = T.PROJECT_ID
AND T.TASK_ID = EI.TASK_ID
AND EI.EXPENDITURE_ID = E.EXPENDITURE_ID
AND E.INCURRED_BY_PERSON_ID = PER.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND (PER.EMPLOYEE_NUMBER IS NOT NULL OR PER.NPW_NUMBER IS NOT NULL)
AND EI.SYSTEM_LINKAGE_FUNCTION = 'ST'
AND EI.JOB_ID = JOB.JOB_ID (+)
AND E.INCURRED_BY_ORGANIZATION_ID = ORG.ORGANIZATION_ID

Columns