View: PA_CE_INTEGRATION_BUDGETS_V

Product:	PA - Projects
Description:	PA_CE_INTEGRATION_BUDGETS_V is a cash forecasting view that shows project and task level resource budgets by period name for raw cost, burdened cost and revenue. For a given budget type, data may be returned for both current and current ori
Implementation/DBA Data:	APPS.PA_CE_INTEGRATION_BUDGETS_V

View Text

SELECT L.RESOURCE_ASSIGNMENT_ID
, M.ALIAS TRX_NUMBER
, V.BUDGET_VERSION_ID
, A.PROJECT_ID
, A.TASK_ID
, DECODE(V.BUDGET_TYPE_CODE
, NULL
, (SELECT NAME
FROM PA_FIN_PLAN_TYPES_VL F
WHERE V.FIN_PLAN_TYPE_ID = F.FIN_PLAN_TYPE_ID)
, V.BUDGET_TYPE_CODE)
, V.CURRENT_FLAG
, V.CURRENT_ORIGINAL_FLAG
, L.START_DATE
, L.END_DATE
, L.PERIOD_NAME
, GL.CURRENCY_CODE
, L.RAW_COST
, L.BURDENED_COST
, L.REVENUE
FROM PA_BUDGET_LINES L
, PA_BUDGET_VERSIONS V
, PA_RESOURCE_LIST_MEMBERS M
, PA_RESOURCE_ASSIGNMENTS A
, PA_PROJECTS_ALL P
, PA_IMPLEMENTATIONS_ALL I
, GL_SETS_OF_BOOKS GL
WHERE L.RESOURCE_ASSIGNMENT_ID = A.RESOURCE_ASSIGNMENT_ID
AND A.RESOURCE_LIST_MEMBER_ID = M.RESOURCE_LIST_MEMBER_ID
AND A.BUDGET_VERSION_ID = V.BUDGET_VERSION_ID
AND NVL(M.MIGRATION_CODE
, '-99') <> 'N'
AND A.PROJECT_ID = V.PROJECT_ID
AND V.PROJECT_ID = P.PROJECT_ID
AND NVL(P.ORG_ID
, -99) = NVL(I.ORG_ID
, -99)
AND I.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND (V.CURRENT_FLAG = 'Y' OR V.CURRENT_ORIGINAL_FLAG = 'Y')

Columns