Product: | PA - Projects |
---|---|
Description: | This view displays detail information for a given transaction by various transaction attributes |
Implementation/DBA Data: | APPS.PA_TXN_ACCUM_V |
SELECT RAD.PROJECT_ID
, RAD.TASK_ID
, RAD.RESOURCE_LIST_MEMBER_ID
, RAD.RESOURCE_LIST_ID
, TA.PA_PERIOD
, TA.GL_PERIOD
, TA.PERSON_ID
, E.FULL_NAME
, TA.JOB_ID
, J.NAME
, TA.ORGANIZATION_ID
, O1.NAME
, TA.VENDOR_ID
, V.VENDOR_NAME
, TA.EXPENDITURE_TYPE
, TA.EVENT_TYPE
, TA.NON_LABOR_RESOURCE
, TA.EXPENDITURE_CATEGORY
, TA.REVENUE_CATEGORY
, TA.NON_LABOR_RESOURCE_ORG_ID
, OT2.NAME
, TA.EVENT_TYPE_CLASSIFICATION
, TA.SYSTEM_LINKAGE_FUNCTION
, TA.WEEK_ENDING_DATE
, TA.TOT_REVENUE
, TA.TOT_RAW_COST
, TA.TOT_BILLABLE_RAW_COST
, TA.TOT_BURDENED_COST
, TA.TOT_BILLABLE_BURDENED_COST
, TA.TOT_QUANTITY
, TA.TOT_LABOR_HOURS
, TA.TOT_BILLABLE_RAW_COST
, TA.TOT_BILLABLE_BURDENED_COST
, TA.TOT_BILLABLE_QUANTITY
, TA.TOT_BILLABLE_LABOR_HOURS
, TA.TOT_CMT_RAW_COST
, TA.TOT_CMT_BURDENED_COST
, TA.TOT_CMT_QUANTITY
FROM PA_RESOURCE_ACCUM_DETAILS RAD
, PA_TXN_ACCUM TA
, HR_ORGANIZATION_UNITS O1
, HR_ORG_UNITS_NO_JOIN O2
, HR_ALL_ORGANIZATION_UNITS_TL OT2
, PA_EMPLOYEES E
, PA_JOBS_V J
, PO_VENDORS V
WHERE RAD.TXN_ACCUM_ID = TA.TXN_ACCUM_ID
AND TA.ORGANIZATION_ID = O1.ORGANIZATION_ID
AND TA.NON_LABOR_RESOURCE_ORG_ID = O2.ORGANIZATION_ID (+)
AND O2.ORGANIZATION_ID = OT2.ORGANIZATION_ID (+)
AND DECODE(OT2.ORGANIZATION_ID
, NULL
, '1'
, OT2.LANGUAGE) = DECODE(OT2.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND TA.PERSON_ID = E.PERSON_ID (+)
AND TA.JOB_ID = J.JOB_ID (+)
AND TA.VENDOR_ID = V.VENDOR_ID (+)