PJO_BASE_PLAN_BY_PA_PERIOD_V

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name

PLAN_VERSION_ID PROJECT_ID TASK_ID PLAN_TYPE_ID PLANNED_FOR_CODE PA_PERIOD GL_PERIOD_NAME PERIOD_YEAR PERIOD_START_DATE PERIOD_END_DATE RBS_ELEMENT_ID ALIAS RBS_HEADER_ID RESOURCE_SOURCE_ID RAW_COST BRDND_COST REVENUE QUANTITY LABOR_QUANTITY UNIT_OF_MEASURE RESOURCE_UOM APPROVED_COST_PLAN_TYPE_FLAG APPROVED_REV_PLAN_TYPE_FLAG RBS_VERSION_ID PRIMARY_COST_FORECAST_FLAG PRIMARY_REV_FORECAST_FLAG ORG_ID

Query

SQL_Statement

SELECT PV.PLAN_VERSION_ID PLAN_VERSION_ID , PV.PROJECT_ID PROJECT_ID , PE.TASK_ID TASK_ID , PV.PLAN_TYPE_ID PLAN_TYPE_ID , PV.PLANNED_FOR_CODE PLANNED_FOR_CODE , PA.PERIOD_NAME PA_PERIOD , GP.PERIOD_NAME GL_PERIOD_NAME , GP.PERIOD_YEAR PERIOD_YEAR , PA.START_DATE PERIOD_START_DATE , PA.END_DATE PERIOD_END_DATE , PE.RBS_ELEMENT_ID RBS_ELEMENT_ID , RBSE.ALIAS ALIAS , RBSV.RBS_HEADER_ID RBS_HEADER_ID , RBSE.RESOURCE_SOURCE_ID RESOURCE_SOURCE_ID , DECODE (PJO_PLAN_VERSION_UTILS.GET_TIME_PHASED_CODE(PV.PLAN_VERSION_ID) ,'P',PLD.TC_RAW_COST, PJO_PLAN_VERSION_UTILS.SPREAD_AMOUNT('L', PLD.START_DATE, PLD.END_DATE, PA.START_DATE, PA.END_DATE, PLD.TC_RAW_COST)) RAW_COST , DECODE (PJO_PLAN_VERSION_UTILS.GET_TIME_PHASED_CODE(PV.PLAN_VERSION_ID) ,'P',PLD.TC_BRDND_COST, PJO_PLAN_VERSION_UTILS.SPREAD_AMOUNT('L', PLD.START_DATE, PLD.END_DATE, PA.START_DATE, PA.END_DATE, PLD.TC_BRDND_COST)) BRDND_COST , DECODE (PJO_PLAN_VERSION_UTILS.GET_TIME_PHASED_CODE(PV.PLAN_VERSION_ID ),'P',PLD.TC_REVENUE, PJO_PLAN_VERSION_UTILS.SPREAD_AMOUNT('L', PLD.START_DATE, PLD.END_DATE, PA.START_DATE, PA.END_DATE, PLD.TC_REVENUE)) REVENUE , DECODE (PJO_PLAN_VERSION_UTILS.GET_TIME_PHASED_CODE(PV.PLAN_VERSION_ID) ,'P',PLD.QUANTITY, PJO_PLAN_VERSION_UTILS.SPREAD_AMOUNT('L', PLD.START_DATE, PLD.END_DATE, PA.START_DATE, PA.END_DATE, PLD.QUANTITY)) QUANTITY , TO_NUMBER(DECODE(PE.RATE_BASED_FLAG, 'N', NULL, DECODE(PE.UNIT_OF_MEASURE,'HOURS', DECODE (PJO_PLAN_VERSION_UTILS.GET_TIME_PHASED_CODE(PV.PLAN_VERSION_ID),'P',PLD.QUANTITY, PJO_PLAN_VERSION_UTILS.SPREAD_AMOUNT('L', PLD.START_DATE, PLD.END_DATE, PA.START_DATE, PA.END_DATE, PLD.QUANTITY)), NULL))) LABOR_QUANTITY , PE.UNIT_OF_MEASURE UNIT_OF_MEASURE , RBSE.UNIT_OF_MEASURE RESOURCE_UOM , PO.APPROVED_COST_PLAN_TYPE_FLAG APPROVED_COST_PLAN_TYPE_FLAG , PO.APPROVED_REV_PLAN_TYPE_FLAG APPROVED_REV_PLAN_TYPE_FLAG , RBSV.RBS_VERSION_ID RBS_VERSION_ID , PO.PRIMARY_COST_FORECAST_FLAG PRIMARY_COST_FORECAST_FLAG , PO.PRIMARY_REV_FORECAST_FLAG PRIMARY_REV_FORECAST_FLAG , PI.ORG_ID ORG_ID FROM PJF_RBS_ELEMENTS_VL RBSE, PJF_RBS_VERSIONS_B RBSV, PJO_PLANNING_OPTIONS PO, PJF_BU_IMPL_ALL_V PI, GL_PERIODS GP, PJF_P_PERIODS_ALL_V PA, GL_SETS_OF_BOOKS SOB, PJO_PLAN_LINE_DETAILS PLD, PJO_PLANNING_ELEMENTS PE, PJO_PLAN_VERSIONS_B PV WHERE PE.RBS_ELEMENT_ID = RBSE.RBS_ELEMENT_ID AND RBSE.RBS_VERSION_ID = RBSV.RBS_VERSION_ID AND PLD.PLANNING_ELEMENT_ID = PE.PLANNING_ELEMENT_ID AND PV.PLAN_VERSION_ID = PE.PLAN_VERSION_ID AND PV.CURRENT_PLAN_STATUS_FLAG = 'Y' AND ((PA.START_DATE <= PLD.END_DATE) AND (PA.END_DATE >= PLD.START_DATE)) AND GP.ADJUSTMENT_PERIOD_FLAG = 'N' AND PI.ORG_ID = PA.ORG_ID AND PI.PRIMARY_LEDGER_ID = SOB.SET_OF_BOOKS_ID AND PA.GL_PERIOD_NAME = GP.PERIOD_NAME AND GP.PERIOD_SET_NAME||''=SOB.PERIOD_SET_NAME