FND Design Data [Home] [Help]

View: PA_CMT_BY_GL_PERIOD_V

Product: PA - Projects
Description: This view displays current commitment totals for lowest level tasks and resources by GL periods.
Implementation/DBA Data: ViewAPPS.PA_CMT_BY_GL_PERIOD_V
View Text

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_CMT_QUANTITY
, 0))
, SUM(NVL(TA.TOT_CMT_RAW_COST
, 0))
, SUM(NVL(TA.TOT_CMT_BURDENED_COST
, 0))
, I.ORG_ID
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
, I.ORG_ID

Columns

Name
PROJECT_ID
TASK_ID
RESOURCE_LIST_MEMBER_ID
RESOURCE_LIST_ID
GL_PERIOD_NAME
PERIOD_START_DATE
PERIOD_END_DATE
CMT_QUANTITY
CMT_RAW_COST
CMT_BURDENED_COST
ORG_ID