VIEW: APPS.PA_TXN_ACCUM_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)