VIEW: APPS.FPA_BUDGET_FORECAST_INFO_V

Source

View Text - Preformatted

SELECT I.ORG_ID, V.PROJECT_ID, V.BUDGET_VERSION_ID, V.BUDGET_TYPE_CODE , G.START_DATE, sum(DECODE (BEM.TIME_PHASED_TYPE_CODE,'G',L.BURDENED_COST, PA_MISC.SPREAD_AMOUNT('L', L.START_DATE, L.END_DATE, G.START_DATE, G.END_DATE, L.BURDENED_COST))) , sum(DECODE (BEM.TIME_PHASED_TYPE_CODE,'G',L.REVENUE, PA_MISC.SPREAD_AMOUNT('L', L.START_DATE, L.END_DATE, G.START_DATE, G.END_DATE, L.REVENUE))) FROM PA_IMPLEMENTATIONS_all I, GL_PERIOD_STATUSES G, PA_BUDGET_LINES L, PA_BUDGET_VERSIONS V, PA_BUDGET_ENTRY_METHODS BEM WHERE V.BUDGET_ENTRY_METHOD_CODE = BEM.BUDGET_ENTRY_METHOD_CODE AND V.CURRENT_FLAG = 'Y' AND ((G.START_DATE <= L.END_DATE) AND (G.END_DATE >= L.START_DATE)) AND V.BUDGET_VERSION_ID = L.BUDGET_VERSION_ID AND I.SET_OF_BOOKS_ID =G.SET_OF_BOOKS_ID AND G.ADJUSTMENT_PERIOD_FLAG = 'N' AND G.APPLICATION_ID = pa_period_process_pkg.application_id AND V.BUDGET_STATUS_CODE = 'B' group by i.org_id, v.project_id, v.BUDGET_VERSION_ID, V.BUDGET_TYPE_CODE , g.start_date

View Text - HTML Formatted

SELECT I.ORG_ID
, V.PROJECT_ID
, V.BUDGET_VERSION_ID
, V.BUDGET_TYPE_CODE
, G.START_DATE
, SUM(DECODE (BEM.TIME_PHASED_TYPE_CODE
, 'G'
, L.BURDENED_COST
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, G.START_DATE
, G.END_DATE
, L.BURDENED_COST)))
, SUM(DECODE (BEM.TIME_PHASED_TYPE_CODE
, 'G'
, L.REVENUE
, PA_MISC.SPREAD_AMOUNT('L'
, L.START_DATE
, L.END_DATE
, G.START_DATE
, G.END_DATE
, L.REVENUE)))
FROM PA_IMPLEMENTATIONS_ALL I
, GL_PERIOD_STATUSES G
, PA_BUDGET_LINES L
, PA_BUDGET_VERSIONS V
, PA_BUDGET_ENTRY_METHODS BEM
WHERE V.BUDGET_ENTRY_METHOD_CODE = BEM.BUDGET_ENTRY_METHOD_CODE
AND V.CURRENT_FLAG = 'Y'
AND ((G.START_DATE <= L.END_DATE)
AND (G.END_DATE >= L.START_DATE))
AND V.BUDGET_VERSION_ID = L.BUDGET_VERSION_ID
AND I.SET_OF_BOOKS_ID =G.SET_OF_BOOKS_ID
AND G.ADJUSTMENT_PERIOD_FLAG = 'N'
AND G.APPLICATION_ID = PA_PERIOD_PROCESS_PKG.APPLICATION_ID
AND V.BUDGET_STATUS_CODE = 'B' GROUP BY I.ORG_ID
, V.PROJECT_ID
, V.BUDGET_VERSION_ID
, V.BUDGET_TYPE_CODE
, G.START_DATE