View: PA_CAPITAL_PROJECTS_V

Product:	PA - Projects
Description:	R10SC Only - View of summary expensed, CIP, capitalizable, capitalized, and total project costs for capital projects
Implementation/DBA Data:	APPS.PA_CAPITAL_PROJECTS_V

View Text

SELECT P.ROWID
, V.PROJECT_ID
, V.PROJECT_NAME
, V.PROJECT_NUMBER
, V.PROJECT_STATUS_CODE
, V.PROJECT_TYPE
, V.INTERFACE_COMPLETE_ASSET_FLAG
, V.INTERFACE_ASSET_COST_CODE
, V.PROJECT_ORGANIZATION
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
, SUBSTR(PA_SECURITY.ALLOW_UPDATE(V.PROJECT_ID)
, 1
, 1)
, SUBSTR(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 1
, 1)
, DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, NULL
, SUM(V.CAPITALIZED_COST))
, DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, NULL
, SUM(V.CAPITALIZABLE_COST))
, DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, NULL
, SUM(V.TOTAL_COSTS))
, DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, NULL
, (SUM(V.TOTAL_COSTS) - SUM(V.CAPITALIZABLE_COST))) EXPENSED
, DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, NULL
, (SUM(V.CAPITALIZABLE_COST) - SUM(V.CAPITALIZED_COST))) CIP_COST
, V.ASSET_ALLOCATION_METHOD
, V.CAPITAL_EVENT_PROCESSING
, V.CAPITAL_COST_TYPE_CODE
, V.BURDEN_AMT_DISPLAY_METHOD
, V.TOTAL_BURDEN_FLAG
, P.ORG_ID
FROM PA_CAPITAL_PROJECTS_BASE_V V
, PA_PROJECTS P
, PA_PROJECT_STATUSES PPS
WHERE PA_SECURITY.ALLOW_QUERY(V.PROJECT_ID) = 'Y'
AND V.PROJECT_ID = P.PROJECT_ID
AND P.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPS.PROJECT_SYSTEM_STATUS_CODE <> 'PURGED' GROUP BY P.ROWID
, V.PROJECT_ID
, V.PROJECT_NAME
, V.PROJECT_NUMBER
, V.PROJECT_STATUS_CODE
, V.PROJECT_TYPE
, V.INTERFACE_COMPLETE_ASSET_FLAG
, V.INTERFACE_ASSET_COST_CODE
, V.PROJECT_ORGANIZATION
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
, V.ASSET_ALLOCATION_METHOD
, V.CAPITAL_EVENT_PROCESSING
, V.CAPITAL_COST_TYPE_CODE
, V.BURDEN_AMT_DISPLAY_METHOD
, V.TOTAL_BURDEN_FLAG
, P.ORG_ID UNION ALL SELECT P.ROWID
, V.PROJECT_ID
, V.PROJECT_NAME
, V.PROJECT_NUMBER
, V.PROJECT_STATUS_CODE
, V.PROJECT_TYPE
, V.INTERFACE_COMPLETE_ASSET_FLAG
, V.INTERFACE_ASSET_COST_CODE
, V.PROJECT_ORGANIZATION
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
, SUBSTR(PA_SECURITY.ALLOW_UPDATE(V.PROJECT_ID)
, 1
, 1)
, SUBSTR(PA_SECURITY.VIEW_LABOR_COSTS(V.PROJECT_ID)
, 1
, 1)
, DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, NULL
, SUM(V.CAPITALIZED_COST))
, DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, NULL
, SUM(V.CAPITALIZABLE_COST))
, DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, NULL
, SUM(V.TOTAL_COSTS))
, DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, NULL
, (SUM(V.TOTAL_COSTS) - SUM(V.CAPITALIZABLE_COST))) EXPENSED
, DECODE(PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE
, 'R'
, NULL
, 0) CIP_COST /* CIP ZERO FOR PUGED PROJECT */
, V.ASSET_ALLOCATION_METHOD
, V.CAPITAL_EVENT_PROCESSING
, V.CAPITAL_COST_TYPE_CODE
, V.BURDEN_AMT_DISPLAY_METHOD
, V.TOTAL_BURDEN_FLAG
, P.ORG_ID
FROM PA_CAPITAL_PROJECTS_BASE_V V
, PA_PROJECTS P
, PA_PROJECT_STATUSES PPS
WHERE PA_SECURITY.ALLOW_QUERY(V.PROJECT_ID) = 'Y'
AND V.PROJECT_ID = P.PROJECT_ID
AND P.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPS.PROJECT_SYSTEM_STATUS_CODE = 'PURGED' GROUP BY P.ROWID
, V.PROJECT_ID
, V.PROJECT_NAME
, V.PROJECT_NUMBER
, V.PROJECT_STATUS_CODE
, V.PROJECT_TYPE
, V.INTERFACE_COMPLETE_ASSET_FLAG
, V.INTERFACE_ASSET_COST_CODE
, V.PROJECT_ORGANIZATION
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
, V.ASSET_ALLOCATION_METHOD
, V.CAPITAL_EVENT_PROCESSING
, V.CAPITAL_COST_TYPE_CODE
, V.BURDEN_AMT_DISPLAY_METHOD
, V.TOTAL_BURDEN_FLAG
, P.ORG_ID

Columns