PJO_DIS_NON_PD_BASE

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_TC_RAW_COST TOTAL_TC_BRDND_COST TOTAL_TC_REVENUE PC_RAW_COST PFC_RAW_COST PC_BRDND_COST PFC_BRDND_COST PC_REVENUE PFC_REVENUE MARGIN_DERIVED_FROM_CODE TC_REVENUE TC_BRDND_COST TC_RAW_COST TASK_ID RBS_ELEMENT_ID

Name

PLAN_LINE_ID

PLAN_VERSION_ID

PLAN_TYPE_ID

PROJECT_ID

PLANNING_ELEMENT_ID

TXN_CURRENCY_CODE

TOTAL_QUANTITY

TOTAL_TC_RAW_COST

TOTAL_TC_BRDND_COST

TOTAL_TC_REVENUE

PC_RAW_COST

PFC_RAW_COST

PC_BRDND_COST

PFC_BRDND_COST

PC_REVENUE

PFC_REVENUE

MARGIN_DERIVED_FROM_CODE

TC_REVENUE

TC_BRDND_COST

TC_RAW_COST

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_TC_RAW_COST, PlanLineEO.TOTAL_TC_BRDND_COST , PlanLineEO.TOTAL_TC_REVENUE, 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, PlanLineEO.TOTAL_TC_REVENUE TC_REVENUE, PlanLineEO.TOTAL_TC_BRDND_COST TC_BRDND_COST, PlanLineEO.TOTAL_TC_RAW_COST TC_RAW_COST, 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 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

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_TC_RAW_COST,

PlanLineEO.TOTAL_TC_BRDND_COST ,

PlanLineEO.TOTAL_TC_REVENUE,

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,

PlanLineEO.TOTAL_TC_REVENUE TC_REVENUE,

PlanLineEO.TOTAL_TC_BRDND_COST TC_BRDND_COST,

PlanLineEO.TOTAL_TC_RAW_COST TC_RAW_COST,

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 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