VIEW: APPS.PA_ACT_BY_GL_PERIOD_V

Source

View Text - Preformatted

SELECT RAD.PROJECT_ID , RAD.TASK_ID , RAD.RESOURCE_LIST_MEMBER_ID , RAD.RESOURCE_LIST_ID , TA.GL_PERIOD , PS.START_DATE , PS.END_DATE , SUM(NVL(TA.TOT_REVENUE, 0)) , SUM(NVL(TA.TOT_RAW_COST, 0)) , SUM(NVL(TA.TOT_BILLABLE_RAW_COST, 0)) , SUM(NVL(TA.TOT_BURDENED_COST, 0)) , SUM(NVL(TA.TOT_BILLABLE_BURDENED_COST, 0)) , SUM(NVL(TA.TOT_QUANTITY, 0)) , SUM(NVL(TA.TOT_LABOR_HOURS, 0)) , SUM(NVL(TA.TOT_BILLABLE_RAW_COST, 0)) , SUM(NVL(TA.TOT_BILLABLE_BURDENED_COST, 0)) , SUM(NVL(TA.TOT_BILLABLE_QUANTITY, 0)) , SUM(NVL(TA.TOT_BILLABLE_LABOR_HOURS, 0)) FROM PA_RESOURCE_ACCUM_DETAILS RAD , PA_TXN_ACCUM TA , GL_PERIOD_STATUSES PS , PA_IMPLEMENTATIONS I WHERE RAD.TXN_ACCUM_ID = TA.TXN_ACCUM_ID AND PS.APPLICATION_ID = pa_period_process_pkg.application_id AND PS.SET_OF_BOOKS_ID = I.SET_OF_BOOKS_ID AND PS.PERIOD_NAME = TA.GL_PERIOD AND PS.ADJUSTMENT_PERIOD_FLAG = 'N' GROUP BY RAD.PROJECT_ID, RAD.TASK_ID, RAD.RESOURCE_LIST_MEMBER_ID, RAD.RESOURCE_LIST_ID, TA.GL_PERIOD, PS.START_DATE, PS.END_DATE

View Text - HTML Formatted

SELECT RAD.PROJECT_ID
, RAD.TASK_ID
, RAD.RESOURCE_LIST_MEMBER_ID
, RAD.RESOURCE_LIST_ID
, TA.GL_PERIOD
, PS.START_DATE
, PS.END_DATE
, SUM(NVL(TA.TOT_REVENUE
, 0))
, SUM(NVL(TA.TOT_RAW_COST
, 0))
, SUM(NVL(TA.TOT_BILLABLE_RAW_COST
, 0))
, SUM(NVL(TA.TOT_BURDENED_COST
, 0))
, SUM(NVL(TA.TOT_BILLABLE_BURDENED_COST
, 0))
, SUM(NVL(TA.TOT_QUANTITY
, 0))
, SUM(NVL(TA.TOT_LABOR_HOURS
, 0))
, SUM(NVL(TA.TOT_BILLABLE_RAW_COST
, 0))
, SUM(NVL(TA.TOT_BILLABLE_BURDENED_COST
, 0))
, SUM(NVL(TA.TOT_BILLABLE_QUANTITY
, 0))
, SUM(NVL(TA.TOT_BILLABLE_LABOR_HOURS
, 0))
FROM PA_RESOURCE_ACCUM_DETAILS RAD
, PA_TXN_ACCUM TA
, GL_PERIOD_STATUSES PS
, PA_IMPLEMENTATIONS I
WHERE RAD.TXN_ACCUM_ID = TA.TXN_ACCUM_ID
AND PS.APPLICATION_ID = PA_PERIOD_PROCESS_PKG.APPLICATION_ID
AND PS.SET_OF_BOOKS_ID = I.SET_OF_BOOKS_ID
AND PS.PERIOD_NAME = TA.GL_PERIOD
AND PS.ADJUSTMENT_PERIOD_FLAG = 'N' GROUP BY RAD.PROJECT_ID
, RAD.TASK_ID
, RAD.RESOURCE_LIST_MEMBER_ID
, RAD.RESOURCE_LIST_ID
, TA.GL_PERIOD
, PS.START_DATE
, PS.END_DATE