PJO_DIS_NON_PD_DETAILS_V

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name

PLAN_LINE_ID PLANNING_ELEMENT_ID TXN_CURRENCY_CODE PLANNING_ELEMENT_ID1 TASK_ID RBS_ELEMENT_ID SPREAD_CURVE_ID PLANNING_START_DATE PLANNING_END_DATE UNIT_OF_MEASURE UOM_CODE PROJECT_ID UNPLANNED_FLAG RA_TASK_DATES_SAME OBJECT_ID1 TOTAL_QUANTITY TOTAL_TC_RAW_COST TOTAL_TC_BRDND_COST TOTAL_TC_REVENUE TOTAL_ACT_QUANTITY TOTAL_TC_ACT_RAW_COST TOTAL_TC_ACT_BRDND_COST PLAN_VERSION_ID1 PLAN_VERSION_ID PLAN_TYPE_ID TC_STD_RAW_COST_RATE TC_STD_BRDND_COST_RATE TC_STD_BILL_RATE PFC_BRDND_COST PC_RAW_COST PFC_RAW_COST PC_BRDND_COST PC_REVENUE PFC_REVENUE REQ_QUANTITY TC_REQ_RAW_COST PC_REQ_RAW_COST PFC_REQ_RAW_COST TC_REQ_BRDND_COST PC_REQ_BRDND_COST PFC_REQ_BRDND_COST PO_QUANTITY TC_PO_RAW_COST PC_PO_RAW_COST TC_PO_BRDND_COST PC_PO_BRDND_COST PFC_PO_BRDND_COST SI_QUANTITY TC_SI_RAW_COST PC_SI_RAW_COST PFC_SI_RAW_COST TC_SI_BRDND_COST PC_SI_BRDND_COST PFC_SI_BRDND_COST EXT_QUANTITY TC_EXT_RAW_COST PC_EXT_RAW_COST PFC_EXT_RAW_COST TC_EXT_BRDND_COST PC_EXT_BRDND_COST PFC_EXT_BRDND_COST TO_QUANTITY TC_TO_RAW_COST PC_TO_RAW_COST PFC_TO_RAW_COST TC_TO_BRDND_COST PC_TO_BRDND_COST PFC_TO_BRDND_COST RCPT_QUANTITY TC_RCPT_RAW_COST PC_RCPT_RAW_COST PFC_RCPT_RAW_COST TC_RCPT_BRDND_COST PC_RCPT_BRDND_COST PFC_RCPT_BRDND_COST ACT_QUANTITY TC_ACT_RAW_COST PC_ACT_RAW_COST PFC_ACT_RAW_COST TC_ACT_BRDND_COST PC_ACT_BRDND_COST PFC_ACT_BRDND_COST TC_ACT_REVENUE PC_ACT_REVENUE PFC_ACT_REVENUE TC_BILL_RATE_OVERRIDE TC_AVERAGE_BILL_RATE TC_BRDND_COST_RATE_OVERRIDE TC_AVERAGE_BRDND_COST_RATE TC_RAW_COST_RATE_OVERRIDE TC_AVERAGE_RAW_COST_RATE TC_REVENUE TC_BRDND_COST TC_RAW_COST QUANTITY TC_STD_BRDND_MULTIPLIER PFC_PO_RAW_COST PC_COST_RATE_DATE PC_COST_RATE_TYPE PC_COST_RATE_DATE_TYPE PC_REV_RATE_DATE_TYPE PC_REV_RATE_DATE PC_REV_RATE_TYPE PFC_COST_RATE_DATE_TYPE PFC_COST_RATE_DATE PFC_COST_RATE_TYPE PFC_REV_RATE_DATE_TYPE PFC_REV_RATE_DATE PFC_REV_RATE_TYPE

Query

SQL_Statement

SELECT PlanLineEO.PLAN_LINE_ID PLAN_LINE_ID, PlanLineEO.PLANNING_ELEMENT_ID PLANNING_ELEMENT_ID, PlanLineEO.TXN_CURRENCY_CODE TXN_CURRENCY_CODE, PlanLineEO.PLANNING_ELEMENT_ID PLANNING_ELEMENT_ID1, PlanningElementEO.TASK_ID TASK_ID, PlanningElementEO.RBS_ELEMENT_ID RBS_ELEMENT_ID , PlanningElementEO.SPREAD_CURVE_ID SPREAD_CURVE_ID, PlanningElementEO.PLANNING_START_DATE PLANNING_START_DATE, PlanningElementEO.PLANNING_END_DATE PLANNING_END_DATE, UnitOfMeasureEO.UNIT_OF_MEASURE UNIT_OF_MEASURE, PlanningElementEO.UNIT_OF_MEASURE UOM_CODE, PlanningElementEO.PROJECT_ID PROJECT_ID, PlanningElementEO.UNPLANNED_FLAG UNPLANNED_FLAG, PlanningElementEO.RA_TASK_DATES_SAME RA_TASK_DATES_SAME, PlanningElementEO.OBJECT_ID1 OBJECT_ID1, PlanLineEO.TOTAL_QUANTITY TOTAL_QUANTITY, PlanLineEO.TOTAL_TC_RAW_COST TOTAL_TC_RAW_COST, PlanLineEO.TOTAL_TC_BRDND_COST TOTAL_TC_BRDND_COST, PlanLineEO.TOTAL_TC_REVENUE TOTAL_TC_REVENUE, PlanLineEO.TOTAL_ACT_QUANTITY TOTAL_ACT_QUANTITY, PlanLineEO.TOTAL_TC_ACT_RAW_COST TOTAL_TC_ACT_RAW_COST, PlanLineEO.TOTAL_TC_ACT_BRDND_COST TOTAL_TC_ACT_BRDND_COST, PlanLineEO.PLAN_VERSION_ID PLAN_VERSION_ID1, PlanVersionEO.PLAN_VERSION_ID PLAN_VERSION_ID, PlanVersionEO.PLAN_TYPE_ID PLAN_TYPE_ID , PlanLineEO.TC_AVG_STD_RAW_COST_RATE TC_STD_RAW_COST_RATE, PlanLineEO.TC_AVG_STD_BRDND_COST_RATE TC_STD_BRDND_COST_RATE, PlanLineEO.TC_AVG_STD_BILL_RATE TC_STD_BILL_RATE, PlanLineEO.TOTAL_PFC_BRDND_COST PFC_BRDND_COST, 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_PC_REVENUE PC_REVENUE, PlanLineEO.TOTAL_PFC_REVENUE PFC_REVENUE, PlanLineEO.TOTAL_REQ_QUANTITY REQ_QUANTITY, PlanLineEO.TOTAL_TC_REQ_RAW_COST TC_REQ_RAW_COST, PlanLineEO.TOTAL_PC_REQ_RAW_COST PC_REQ_RAW_COST, PlanLineEO.TOTAL_PFC_REQ_RAW_COST PFC_REQ_RAW_COST, PlanLineEO.TOTAL_TC_REQ_BRDND_COST TC_REQ_BRDND_COST, PlanLineEO.TOTAL_PC_REQ_BRDND_COST pc_req_brdnd_cost, PlanLineEO.TOTAL_PFC_REQ_BRDND_COST PFC_REQ_BRDND_COST, PlanLineEO.TOTAL_PO_QUANTITY po_quantity, PlanLineEO.TOTAL_TC_PO_RAW_COST TC_PO_RAW_COST, PlanLineEO.TOTAL_PC_PO_RAW_COST PC_PO_RAW_COST, PlanLineEO.TOTAL_TC_PO_BRDND_COST TC_PO_BRDND_COST, PlanLineEO.TOTAL_PC_PO_BRDND_COST PC_PO_BRDND_COST, PlanLineEO.TOTAL_PFC_PO_BRDND_COST PFC_PO_BRDND_COST, PlanLineEO.TOTAL_SI_QUANTITY SI_QUANTITY, PlanLineEO.TOTAL_TC_SI_RAW_COST TC_SI_RAW_COST, PlanLineEO.TOTAL_PC_SI_RAW_COST PC_SI_RAW_COST, PlanLineEO.TOTAL_PFC_SI_RAW_COST PFC_SI_RAW_COST, PlanLineEO.TOTAL_TC_SI_BRDND_COST TC_SI_BRDND_COST, PlanLineEO.TOTAL_PC_SI_BRDND_COST PC_SI_BRDND_COST, PlanLineEO.TOTAL_PFC_SI_BRDND_COST PFC_SI_BRDND_COST, PlanLineEO.TOTAL_EXT_QUANTITY EXT_QUANTITY, PlanLineEO.TOTAL_TC_EXT_RAW_COST TC_EXT_RAW_COST, PlanLineEO.TOTAL_PC_EXT_RAW_COST PC_EXT_RAW_COST, PlanLineEO.TOTAL_PFC_EXT_RAW_COST PFC_EXT_RAW_COST, PlanLineEO.TOTAL_TC_EXT_BRDND_COST TC_EXT_BRDND_COST, PlanLineEO.TOTAL_PC_EXT_BRDND_COST PC_EXT_BRDND_COST, PlanLineEO.TOTAL_PFC_EXT_BRDND_COST PFC_EXT_BRDND_COST, PlanLineEO.TOTAL_TO_QUANTITY TO_QUANTITY, PlanLineEO.TOTAL_TC_TO_RAW_COST TC_TO_RAW_COST, PlanLineEO.TOTAL_PC_TO_RAW_COST PC_TO_RAW_COST, PlanLineEO.TOTAL_PFC_TO_RAW_COST PFC_TO_RAW_COST, PlanLineEO.TOTAL_TC_TO_BRDND_COST TC_TO_BRDND_COST, PlanLineEO.TOTAL_PC_TO_BRDND_COST PC_TO_BRDND_COST, PlanLineEO.TOTAL_PFC_TO_BRDND_COST PFC_TO_BRDND_COST, PlanLineEO.TOTAL_RCPT_QUANTITY RCPT_QUANTITY, PlanLineEO.TOTAL_TC_RCPT_RAW_COST TC_RCPT_RAW_COST, PlanLineEO.TOTAL_PC_RCPT_RAW_COST PC_RCPT_RAW_COST, PlanLineEO.TOTAL_PFC_RCPT_RAW_COST PFC_RCPT_RAW_COST, PlanLineEO.TOTAL_TC_RCPT_BRDND_COST TC_RCPT_BRDND_COST, PlanLineEO.TOTAL_PC_RCPT_BRDND_COST PC_RCPT_BRDND_COST, PlanLineEO.TOTAL_PFC_RCPT_BRDND_COST PFC_RCPT_BRDND_COST, PlanLineEO.TOTAL_ACT_QUANTITY ACT_QUANTITY, PlanLineEO.TOTAL_TC_ACT_RAW_COST TC_ACT_RAW_COST, PlanLineEO.TOTAL_PC_ACT_RAW_COST PC_ACT_RAW_COST, PlanLineEO.TOTAL_PFC_ACT_RAW_COST PFC_ACT_RAW_COST, PlanLineEO.TOTAL_TC_ACT_BRDND_COST TC_ACT_BRDND_COST, PlanLineEO.TOTAL_PC_ACT_BRDND_COST PC_ACT_BRDND_COST, PlanLineEO.TOTAL_PFC_ACT_BRDND_COST PFC_ACT_BRDND_COST, PlanLineEO.TOTAL_TC_ACT_REVENUE TC_ACT_REVENUE, PlanLineEO.TOTAL_PC_ACT_REVENUE PC_ACT_REVENUE, PlanLineEO.TOTAL_PFC_ACT_REVENUE PFC_ACT_REVENUE, PlanLineEO.TC_BILL_RATE_OVERRIDE TC_BILL_RATE_OVERRIDE, PlanLineEO.TC_AVERAGE_BILL_RATE TC_AVERAGE_BILL_RATE, PlanLineEO.TC_BRDND_COST_RATE_OVERRIDE TC_BRDND_COST_RATE_OVERRIDE, PlanLineEO.TC_AVERAGE_BRDND_COST_RATE TC_AVERAGE_BRDND_COST_RATE, PlanLineEO.TC_RAW_COST_RATE_OVERRIDE TC_RAW_COST_RATE_OVERRIDE, PlanLineEO.TC_AVERAGE_RAW_COST_RATE TC_AVERAGE_RAW_COST_RATE, PlanLineEO.TOTAL_TC_REVENUE TC_REVENUE, PlanLineEO.TOTAL_TC_BRDND_COST TC_BRDND_COST, PlanLineEO.TOTAL_TC_RAW_COST TC_RAW_COST, PlanLineEO.TOTAL_QUANTITY QUANTITY, PlanLineEO.TC_AVG_STD_BRDND_MULTIPLIER TC_STD_BRDND_MULTIPLIER, PlanLineEO.TOTAL_PFC_PO_RAW_COST PFC_PO_RAW_COST, (SELECT PPD.PC_COST_RATE_DATE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PC_COST_RATE_DATE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PC_COST_RATE_DATE, (SELECT PPD.PC_COST_RATE_TYPE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PC_COST_RATE_TYPE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PC_COST_RATE_TYPE , (SELECT PPD.PC_COST_RATE_DATE_TYPE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PC_COST_RATE_DATE_TYPE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PC_COST_RATE_DATE_TYPE , (SELECT PPD.PC_REV_RATE_DATE_TYPE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PC_REV_RATE_DATE_TYPE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PC_REV_RATE_DATE_TYPE , (SELECT PPD.PC_REV_RATE_DATE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PC_REV_RATE_DATE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PC_REV_RATE_DATE , (SELECT PPD.PC_REV_RATE_TYPE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PC_REV_RATE_TYPE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PC_REV_RATE_TYPE , (SELECT PPD.PFC_COST_RATE_DATE_TYPE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PFC_COST_RATE_DATE_TYPE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PFC_COST_RATE_DATE_TYPE , (SELECT PPD.PFC_COST_RATE_DATE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PFC_COST_RATE_DATE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PFC_COST_RATE_DATE , (SELECT PPD.PFC_COST_RATE_TYPE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PFC_COST_RATE_TYPE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PFC_COST_RATE_TYPE, (SELECT PPD.PFC_REV_RATE_DATE_TYPE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PFC_REV_RATE_DATE_TYPE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PFC_REV_RATE_DATE_TYPE , (SELECT PPD.PFC_REV_RATE_DATE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PFC_REV_RATE_DATE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PFC_REV_RATE_DATE , (SELECT PPD.PFC_REV_RATE_TYPE FROM PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE <> 'N' UNION ALL SELECT PPLD.PFC_REV_RATE_TYPE FROM PJO_PLAN_LINE_DETAILS PPLD , PJO_PLANNING_OPTIONS PPD WHERE PPD.PLAN_VERSION_ID = PLANVERSIONEO.PLAN_VERSION_ID AND PPD.TIME_PHASED_CODE = 'N' AND PPLD.PLAN_VERSION_ID = PPD.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID =PLANLINEEO.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE = PLANLINEEO.TXN_CURRENCY_CODE ) AS PFC_REV_RATE_TYPE FROM PJO_PLAN_LINES PlanLineEO, PJO_PLANNING_ELEMENTS PlanningElementEO, PJO_PLAN_VERSIONS_B PlanVersionEO, PJF_UNITS_OF_MEASURE_V UnitOfMeasureEO 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 PlanningElementEO.UNIT_OF_MEASURE = UnitOfMeasureEO.UOM_CODE(+)