PJO_BASE_PLAN_BY_GL_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 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 , GPS.PERIOD_NAME GL_PERIOD_NAME , GPS.PERIOD_YEAR PERIOD_YEAR , GPS.START_DATE PERIOD_START_DATE , GPS.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) ,'G',PLD.TC_RAW_COST, PJO_PLAN_VERSION_UTILS.SPREAD_AMOUNT('L', PLD.START_DATE, PLD.END_DATE, GPS.START_DATE, GPS.END_DATE, PLD.TC_RAW_COST)) RAW_COST , DECODE (PJO_PLAN_VERSION_UTILS.GET_TIME_PHASED_CODE(PV.PLAN_VERSION_ID) ,'G',PLD.TC_BRDND_COST, PJO_PLAN_VERSION_UTILS.SPREAD_AMOUNT('L', PLD.START_DATE, PLD.END_DATE, GPS.START_DATE, GPS.END_DATE, PLD.TC_BRDND_COST)) BRDND_COST , DECODE (PJO_PLAN_VERSION_UTILS.GET_TIME_PHASED_CODE(PV.PLAN_VERSION_ID ),'G',PLD.TC_REVENUE, PJO_PLAN_VERSION_UTILS.SPREAD_AMOUNT('L', PLD.START_DATE, PLD.END_DATE, GPS.START_DATE, GPS.END_DATE, PLD.TC_REVENUE)) REVENUE , DECODE (PJO_PLAN_VERSION_UTILS.GET_TIME_PHASED_CODE(PV.PLAN_VERSION_ID) ,'G',PLD.QUANTITY, PJO_PLAN_VERSION_UTILS.SPREAD_AMOUNT('L', PLD.START_DATE, PLD.END_DATE, GPS.START_DATE, GPS.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),'G',PLD.QUANTITY, PJO_PLAN_VERSION_UTILS.SPREAD_AMOUNT('L', PLD.START_DATE, PLD.END_DATE, GPS.START_DATE, GPS.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_PERIOD_STATUSES GPS, 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 ((GPS.START_DATE <= PLD.END_DATE) AND (GPS.END_DATE >= PLD.START_DATE)) AND PI.PRIMARY_LEDGER_ID =GPS.SET_OF_BOOKS_ID AND GPS.ADJUSTMENT_PERIOD_FLAG = 'N' AND GPS.APPLICATION_ID = PJF_PERIODS_GRP.PERIOD_APPLICATION_ID