1. Tables and Views for Project Management
  2. PJO_DIS_NON_PD_PRIOR_V

PJO_DIS_NON_PD_PRIOR_V

Details

  • Schema: FUSION

  • Object owner: PJO

  • Object type: VIEW

Columns

Name

PLAN_LINE_ID

PLAN_VERSION_ID

PLAN_TYPE_ID

PROJECT_ID

PLANNING_ELEMENT_ID

TXN_CURRENCY_CODE

TOTAL_QUANTITY

TOTAL_ACT_QUANTITY

TOTAL_ETC_QUANTITY

TOTAL_TC_RAW_COST

TOTAL_TC_ACT_RAW_COST

TOTAL_TC_ETC_RAW_COST

TOTAL_TC_BRDND_COST

TOTAL_TC_ACT_BRDND_COST

TOTAL_TC_ETC_BRDND_COST

TOTAL_TC_REVENUE

TOTAL_TC_ACT_REVENUE

TOTAL_TC_ETC_REVENUE

TOTAL_TC_MARGIN

TOTAL_TC_ACT_MARGIN

PC_RAW_COST

PFC_RAW_COST

PC_BRDND_COST

PFC_BRDND_COST

PC_REVENUE

PFC_REVENUE

MARGIN_DERIVED_FROM_CODE

TASK_ID

RBS_ELEMENT_ID

Query

SQL_Statement

SELECT

PlanLineEO.PLAN_LINE_ID,

PlanVersionEO.PLAN_VERSION_ID,

PlanVersionEO.PLAN_TYPE_ID,

PlanVersionEO.PROJECT_ID,

PlanLineEO.PLANNING_ELEMENT_ID,

PlanLineEO.TXN_CURRENCY_CODE,

PlanLineEO.TOTAL_QUANTITY,

PlanLineEO.TOTAL_ACT_QUANTITY,

NULLIF((NVL(PlanLineEO.TOTAL_QUANTITY,0)-NVL(PlanLineEO.TOTAL_ACT_QUANTITY,0)),0) TOTAL_ETC_QUANTITY,

PlanLineEO.TOTAL_TC_RAW_COST,

PlanLineEO.TOTAL_TC_ACT_RAW_COST,

NULLIF((NVL(PlanLineEO.TOTAL_TC_RAW_COST,0)-NVL(PlanLineEO.TOTAL_TC_ACT_RAW_COST,0)),0) TOTAL_TC_ETC_RAW_COST,

PlanLineEO.TOTAL_TC_BRDND_COST ,

PlanLineEO.TOTAL_TC_ACT_BRDND_COST,

NULLIF((NVL(PlanLineEO.TOTAL_TC_BRDND_COST,0)-NVL(PlanLineEO.TOTAL_TC_ACT_BRDND_COST,0)),0) TOTAL_TC_ETC_BRDND_COST,

PlanLineEO.TOTAL_TC_REVENUE,

PlanLineEO.TOTAL_TC_ACT_REVENUE,

NULLIF((NVL(PlanLineEO.TOTAL_TC_REVENUE,0)-NVL(PlanLineEO.TOTAL_TC_ACT_REVENUE,0)),0) TOTAL_TC_ETC_REVENUE,

DECODE(PjoPlanningOptions.MARGIN_DERIVED_FROM_CODE,'B',

DECODE((NVL(PlanLineEO.TOTAL_TC_REVENUE,0) - NVL(PlanLineEO.TOTAL_TC_BRDND_COST,0)),0,NULL,(NVL(PlanLineEO.TOTAL_TC_REVENUE,0) - NVL(PlanLineEO.TOTAL_TC_BRDND_COST,0))),

DECODE((NVL(PlanLineEO.TOTAL_TC_REVENUE,0) - NVL(PlanLineEO.TOTAL_TC_RAW_COST,0)),0,NULL,(NVL(PlanLineEO.TOTAL_TC_REVENUE,0) - NVL(PlanLineEO.TOTAL_TC_RAW_COST,0)))) TOTAL_TC_MARGIN,

DECODE(PjoPlanningOptions.MARGIN_DERIVED_FROM_CODE,'B',

DECODE((NVL(PlanLineEO.TOTAL_TC_ACT_REVENUE,0) - NVL(PlanLineEO.TOTAL_TC_ACT_BRDND_COST,0)),0,NULL,(NVL(PlanLineEO.TOTAL_TC_ACT_REVENUE,0) - NVL(PlanLineEO.TOTAL_TC_ACT_BRDND_COST,0))),

DECODE((NVL(PlanLineEO.TOTAL_TC_ACT_REVENUE,0) - NVL(PlanLineEO.TOTAL_TC_ACT_RAW_COST,0)),0,NULL,(NVL(PlanLineEO.TOTAL_TC_ACT_REVENUE,0) - NVL(PlanLineEO.TOTAL_TC_ACT_RAW_COST,0)))) TOTAL_TC_ACT_MARGIN,

PlanLineEO.TOTAL_PC_RAW_COST PC_RAW_COST,

PlanLineEO.TOTAL_PFC_RAW_COST PFC_RAW_COST,

PlanLineEO.TOTAL_PC_BRDND_COST PC_BRDND_COST,

PlanLineEO.TOTAL_PFC_BRDND_COST PFC_BRDND_COST,

PlanLineEO.TOTAL_PC_REVENUE PC_REVENUE,

PlanLineEO.TOTAL_PFC_REVENUE PFC_REVENUE,

PjoPlanningOptions.MARGIN_DERIVED_FROM_CODE,

PlanningElementEO.TASK_ID,

PlanningElementEO.RBS_ELEMENT_ID

FROM PJO_PLAN_LINES PlanLineEO,

PJO_PLANNING_ELEMENTS PlanningElementEO,

PJO_PLAN_VERSIONS_B PlanVersionEO,

PJO_PLANNING_OPTIONS PjoPlanningOptions

WHERE PlanningElementEO.PLANNING_ELEMENT_ID = PlanLineEO.PLANNING_ELEMENT_ID

AND PlanVersionEO.PLAN_VERSION_ID = PlanLineEO.PLAN_VERSION_ID

AND PlanningElementEO.PLAN_VERSION_ID = PlanVersionEO.PLAN_VERSION_ID

AND PlanVersionEO.PLAN_STATUS_CODE = 'B'

AND PlanVersionEO.CURRENT_PLAN_STATUS_FLAG = 'Y'

AND PlanVersionEO.PLAN_CLASS_CODE = 'FORECAST'

AND PlanVersionEO.VERSION_NUMBER = (SELECT DECODE((A.VERSION_NUMBER-1),0,-99,(A.VERSION_NUMBER-1))

FROM PJO_PLAN_VERSIONS_B A

WHERE A.PLAN_TYPE_ID = PlanVersionEO.PLAN_TYPE_ID

AND A.PROJECT_ID = PlanVersionEO.PROJECT_ID

AND A.PLAN_STATUS_CODE = 'B'

AND A.CURRENT_PLAN_STATUS_FLAG = 'Y'

AND A.PLAN_CLASS_CODE = 'FORECAST')

AND PjoPlanningOptions.PLAN_VERSION_ID = PlanVersionEO.PLAN_VERSION_ID

AND PjoPlanningOptions.PLAN_VERSION_ID = PlanLineEO.PLAN_VERSION_ID

AND PjoPlanningOptions.PLAN_VERSION_ID = PlanningElementEO.PLAN_VERSION_ID