PJO_DESK_DIS_SINGLE_PD_V

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name

PLANNING_ELEMENT_ID TXN_CURRENCY_CODE START_DATE ACT_QUANTITY BURD_REJ_CODE BURDEN_MULTIPLIER CHANGE_QUANTITY COST_REJ_CODE CURRENT_PERIOD_NAME DISPLAY_NAME END_DATE END_PERIOD_NAME ETC_QUANTITY ETC_QUANTITY_ORIG ETC_START_DATE FROM_ANCHOR_POSITION FROM_ANCHOR_START MARGIN_DERIVED_FROM_CODE OBJECT_ID1 PC_ACT_BRDND_COST PC_ACT_MARGIN PC_ACT_RAW_COST PC_ACT_RAW_COST_RATE PC_ACT_REVENUE PC_BRDND_COST PC_CHANGE_BRDND_COST PC_CHANGE_RAW_COST PC_CHANGE_REVENUE PC_COST_EXCHANGE_RATE PC_COST_RATE_DATE PC_COST_RATE_DATE_TYPE PC_COST_RATE_TYPE PC_ETC_BRDND_COST PC_ETC_RAW_COST PC_ETC_REVENUE PC_MARGIN PC_MARGIN_PCT PC_RAW_COST PC_REJ_CODE PC_REV_EXCHANGE_RATE PC_REV_RATE_DATE PC_REV_RATE_DATE_TYPE PC_REV_RATE_TYPE PC_REVENUE PERIOD_NAME PERIOD_PROFILE_ID PFC_ACT_BRDND_COST PFC_ACT_MARGIN PFC_ACT_RAW_COST PFC_ACT_RAW_COST_RATE PFC_ACT_REVENUE PFC_BRDND_COST PFC_CHANGE_BRDND_COST PFC_CHANGE_RAW_COST PFC_CHANGE_REVENUE PFC_COST_EXCHANGE_RATE PFC_COST_RATE_DATE PFC_COST_RATE_DATE_TYPE PFC_COST_RATE_TYPE PFC_ETC_BRDND_COST PFC_ETC_RAW_COST PFC_ETC_REVENUE PFC_MARGIN PFC_MARGIN_PCT PFC_RAW_COST PFC_REJ_CODE PFC_REV_EXCHANGE_RATE PFC_REV_RATE_DATE PFC_REV_RATE_DATE_TYPE PFC_REV_RATE_TYPE PFC_REVENUE PLAN_CLASS_CODE PLAN_LINE_ID PLAN_TYPE_ID PLAN_VERSION_ID PLANNING_END_DATE PLANNING_START_DATE PROJECT_CURRENCY_CODE PROJECT_ID PROJFUNC_CURRENCY_CODE QUANTITY QUANTITY_ORIG RBS_ELEMENT_ID SP_FIXED_DATE START_PERIOD_NAME TASK_ID TC_ACT_BILL_RATE TC_ACT_BRDND_COST TC_ACT_BRDND_COST_RATE TC_ACT_MARGIN TC_ACT_RAW_COST TC_ACT_RAW_COST_RATE TC_ACT_REVENUE TC_BILL_RATE TC_BILL_RATE_ORIG TC_BRDND_COST TC_BRDND_COST_ORIG TC_BRDND_COST_RATE TC_BRDND_COST_RATE_ORIG TC_CHANGE_BRDND_COST TC_CHANGE_RAW_COST TC_CHANGE_REVENUE TC_ETC_BRDND_COST TC_ETC_BRDND_COST_ORIG TC_ETC_RAW_COST TC_ETC_RAW_COST_ORIG TC_ETC_REVENUE TC_ETC_REVENUE_ORIG TC_MARGIN TC_MARGIN_PCT TC_RAW_COST TC_RAW_COST_ORIG TC_RAW_COST_RATE TC_RAW_COST_RATE_ORIG TC_REVENUE TC_REVENUE_ORIG UNIT_OF_MEASURE UOM_CODE SPREAD_CURVE_ID REQ_QUANTITY PO_QUANTITY SI_QUANTITY EXT_QUANTITY TC_REQ_RAW_COST TC_PO_RAW_COST TC_SI_RAW_COST TC_EXT_RAW_COST TC_REQ_BRDND_COST TC_PO_BRDND_COST TC_SI_BRDND_COST TC_EXT_BRDND_COST PFC_PO_RAW_COST PC_EXT_BRDND_COST PC_EXT_RAW_COST PC_PO_BRDND_COST PC_REQ_BRDND_COST PC_REQ_RAW_COST PC_SI_RAW_COST PFC_ACT_BILL_RATE PFC_ACT_BRDND_COST_RATE PC_ACT_BILL_RATE PC_ACT_BRDND_COST_RATE PFC_EXT_BRDND_COST PFC_PO_BRDND_COST PFC_REQ_BRDND_COST PFC_REQ_RAW_COST PFC_SI_BRDND_COST PC_PO_RAW_COST PFC_SI_RAW_COST PC_SI_BRDND_COST PFC_EXT_RAW_COST TC_STD_BILL_RATE TC_STD_BRDND_COST_RATE TC_STD_RAW_COST_RATE TC_STD_BRDND_MULTIPLIER TC_MARKUP_PERCENT SESSION_ID TO_QUANTITY TC_TO_RAW_COST TC_TO_BRDND_COST RCPT_QUANTITY TC_RCPT_RAW_COST TC_RCPT_BRDND_COST PC_TO_RAW_COST PC_TO_BRDND_COST PFC_TO_RAW_COST PFC_TO_BRDND_COST PC_RCPT_RAW_COST PC_RCPT_BRDND_COST PFC_RCPT_RAW_COST PFC_RCPT_BRDND_COST MANUAL_SPREAD_FLAG

Query

SQL_Statement

SELECT PPL.PLANNING_ELEMENT_ID, PPL.TXN_CURRENCY_CODE, PPLD.START_DATE, PPLD.ACT_QUANTITY, TO_NUMBER(NULL) AS BURD_REJ_CODE, TO_NUMBER(NULL) AS BURDEN_MULTIPLIER, TO_NUMBER(NULL) AS CHANGE_QUANTITY, TO_NUMBER(NULL) AS COST_REJ_CODE, TO_NUMBER(NULL) AS CURRENT_PERIOD_NAME, TO_NUMBER(NULL) AS DISPLAY_NAME, PPLD.END_DATE, TO_NUMBER(NULL) AS END_PERIOD_NAME, DECODE(SIGN(PPLD.END_DATE - PPV.ETC_START_DATE),-1,TO_NUMBER(NULL), NULLIF((NVL(PPLD.QUANTITY,0)-NVL(PPLD.ACT_QUANTITY,0)),0)) AS ETC_QUANTITY, TO_NUMBER(NULL) AS ETC_QUANTITY_ORIG, PPV.ETC_START_DATE, TO_NUMBER(NULL) AS FROM_ANCHOR_POSITION, TO_NUMBER(NULL) AS FROM_ANCHOR_START, PPO.MARGIN_DERIVED_FROM_CODE, PPO.OBJECT_ID1, PPLD.PC_ACT_BRDND_COST, NULLIF(DECODE(PPO.MARGIN_DERIVED_FROM_CODE,'B',TO_NUMBER(NVL(PPLD.PC_ACT_REVENUE,0) - NVL(PPLD.PC_ACT_BRDND_COST,0)),TO_NUMBER(NVL(PPLD.PC_ACT_REVENUE,0) - NVL(PPLD.PC_ACT_RAW_COST,0))),0) AS PC_ACT_MARGIN, PPLD.PC_ACT_RAW_COST, DECODE(PPLD.ACT_QUANTITY,NULL,TO_NUMBER(NULL),0,TO_NUMBER(NULL),PPLD.PC_ACT_RAW_COST/PPLD.ACT_QUANTITY) AS PC_ACT_RAW_COST_RATE, PPLD.PC_ACT_REVENUE, PPLD.PC_BRDND_COST, TO_NUMBER(NULL) AS PC_CHANGE_BRDND_COST, TO_NUMBER(NULL) AS PC_CHANGE_RAW_COST, TO_NUMBER(NULL) AS PC_CHANGE_REVENUE, PPLD.PC_COST_EXCHANGE_RATE, PPLD.PC_COST_RATE_DATE, PPLD.PC_COST_RATE_DATE_TYPE, PPLD.PC_COST_RATE_TYPE, DECODE(SIGN(PPLD.END_DATE - PPV.ETC_START_DATE),-1,TO_NUMBER(NULL), NULLIF((NVL(PPLD.PC_BRDND_COST,0)-NVL(PPLD.PC_ACT_BRDND_COST,0)),0)) AS PC_ETC_BRDND_COST, DECODE(SIGN(PPLD.END_DATE - PPV.ETC_START_DATE),-1,TO_NUMBER(NULL), NULLIF((NVL(PPLD.PC_RAW_COST,0)-NVL(PPLD.PC_ACT_RAW_COST,0)),0)) AS PC_ETC_RAW_COST, DECODE(SIGN(PPLD.END_DATE - PPV.ETC_START_DATE),-1,TO_NUMBER(NULL), NULLIF((NVL(PPLD.PC_REVENUE,0)-NVL(PPLD.PC_ACT_REVENUE,0)),0)) AS PC_ETC_REVENUE, NULLIF(DECODE(PPO.MARGIN_DERIVED_FROM_CODE,'B',TO_NUMBER(NVL(PPLD.PC_REVENUE,0) - NVL(PPLD.PC_BRDND_COST,0)),TO_NUMBER(NVL(PPLD.PC_REVENUE,0) - NVL(PPLD.PC_RAW_COST,0))),0) AS PC_MARGIN, ((DECODE(PPO.MARGIN_DERIVED_FROM_CODE,'B',TO_NUMBER(NVL(PPLD.PC_REVENUE,0) - NVL(PPLD.PC_BRDND_COST,0)),TO_NUMBER(NVL(PPLD.PC_REVENUE,0) - NVL(PPLD.PC_RAW_COST,0))))/(DECODE(PPLD.PC_REVENUE,0,TO_NUMBER(NULL),PPLD.PC_REVENUE))) AS PC_MARGIN_PCT, PPLD.PC_RAW_COST, TO_NUMBER(NULL) AS PC_REJ_CODE, PPLD.PC_REV_EXCHANGE_RATE, PPLD.PC_REV_RATE_DATE, PPLD.PC_REV_RATE_DATE_TYPE, PPLD.PC_REV_RATE_TYPE, PPLD.PC_REVENUE, PPLD.PERIOD_NAME, PPO.PERIOD_PROFILE_ID, PPLD.PFC_ACT_BRDND_COST, NULLIF(DECODE(PPO.MARGIN_DERIVED_FROM_CODE,'B',TO_NUMBER(NVL(PPLD.PFC_ACT_REVENUE,0) - NVL(PPLD.PFC_ACT_BRDND_COST,0)),TO_NUMBER(NVL(PPLD.PFC_ACT_REVENUE,0) - NVL(PPLD.PFC_ACT_RAW_COST,0))),0) AS PFC_ACT_MARGIN, PPLD.PFC_ACT_RAW_COST, DECODE(PPLD.ACT_QUANTITY,NULL,TO_NUMBER(NULL),0,TO_NUMBER(NULL),PPLD.PFC_ACT_RAW_COST/PPLD.ACT_QUANTITY) AS PFC_ACT_RAW_COST_RATE, PPLD.PFC_ACT_REVENUE, PPLD.PFC_BRDND_COST, TO_NUMBER(NULL) AS PFC_CHANGE_BRDND_COST, TO_NUMBER(NULL) AS PFC_CHANGE_RAW_COST, TO_NUMBER(NULL) AS PFC_CHANGE_REVENUE, PPLD.PFC_COST_EXCHANGE_RATE, PPLD.PFC_COST_RATE_DATE, PPLD.PFC_COST_RATE_DATE_TYPE, PPLD.PFC_COST_RATE_TYPE, DECODE(SIGN(PPLD.END_DATE - PPV.ETC_START_DATE),-1,TO_NUMBER(NULL), NULLIF((NVL(PPLD.PFC_BRDND_COST,0)-NVL(PPLD.PFC_ACT_BRDND_COST,0)),0)) AS PFC_ETC_BRDND_COST, DECODE(SIGN(PPLD.END_DATE - PPV.ETC_START_DATE),-1,TO_NUMBER(NULL), NULLIF((NVL(PPLD.PFC_RAW_COST,0)-NVL(PPLD.PFC_ACT_RAW_COST,0)),0)) AS PFC_ETC_RAW_COST, DECODE(SIGN(PPLD.END_DATE - PPV.ETC_START_DATE),-1,TO_NUMBER(NULL), NULLIF((NVL(PPLD.PFC_REVENUE,0)-NVL(PPLD.PFC_ACT_REVENUE,0)),0)) AS PFC_ETC_REVENUE, NULLIF(DECODE(PPO.MARGIN_DERIVED_FROM_CODE,'B',TO_NUMBER(NVL(PPLD.PFC_REVENUE,0) - NVL(PPLD.PFC_BRDND_COST,0)),TO_NUMBER(NVL(PPLD.PFC_REVENUE,0) - NVL(PPLD.PFC_RAW_COST,0))),0) AS PFC_MARGIN, ((DECODE(PPO.MARGIN_DERIVED_FROM_CODE,'B',TO_NUMBER(NVL(PPLD.PFC_REVENUE,0) - NVL(PPLD.PFC_BRDND_COST,0)),TO_NUMBER(NVL(PPLD.PFC_REVENUE,0) - NVL(PPLD.PFC_RAW_COST,0))))/(DECODE(PPLD.PFC_REVENUE,0,TO_NUMBER(NULL),PPLD.PFC_REVENUE))) AS PFC_MARGIN_PCT, PPLD.PFC_RAW_COST, TO_NUMBER(NULL) AS PFC_REJ_CODE, PPLD.PFC_REV_EXCHANGE_RATE, PPLD.PFC_REV_RATE_DATE, PPLD.PFC_REV_RATE_DATE_TYPE, PPLD.PFC_REV_RATE_TYPE, PPLD.PFC_REVENUE, PPV.PLAN_CLASS_CODE, PPL.PLAN_LINE_ID, PPV.PLAN_TYPE_ID, PPV.PLAN_VERSION_ID, PPE.PLANNING_END_DATE, PPE.PLANNING_START_DATE, PPA.PROJECT_CURRENCY_CODE, PPV.PROJECT_ID, PPA.PROJFUNC_CURRENCY_CODE, PPLD.QUANTITY, PPLD.QUANTITY AS QUANTITY_ORIG, PPE.RBS_ELEMENT_ID, TO_DATE(NULL) AS SP_FIXED_DATE, TO_NUMBER(NULL) AS START_PERIOD_NAME, PPE.TASK_ID, DECODE(PPLD.ACT_QUANTITY,NULL,TO_NUMBER(NULL),0,TO_NUMBER(NULL),PPLD.TC_ACT_REVENUE/PPLD.ACT_QUANTITY) AS TC_ACT_BILL_RATE, PPLD.TC_ACT_BRDND_COST, DECODE(PPLD.ACT_QUANTITY,NULL,TO_NUMBER(NULL),0,TO_NUMBER(NULL),PPLD.TC_ACT_BRDND_COST/PPLD.ACT_QUANTITY) AS TC_ACT_BRDND_COST_RATE, NULLIF(DECODE(PPO.MARGIN_DERIVED_FROM_CODE,'B',TO_NUMBER(NVL(PPLD.TC_ACT_REVENUE,0) - NVL(PPLD.TC_ACT_BRDND_COST,0)),TO_NUMBER(NVL(PPLD.TC_ACT_REVENUE,0) - NVL(PPLD.TC_ACT_RAW_COST,0))),0) AS TC_ACT_MARGIN, PPLD.TC_ACT_RAW_COST, DECODE(PPLD.ACT_QUANTITY,NULL,TO_NUMBER(NULL),0,TO_NUMBER(NULL),PPLD.TC_ACT_RAW_COST/PPLD.ACT_QUANTITY) AS TC_ACT_RAW_COST_RATE, PPLD.TC_ACT_REVENUE, DECODE(NVL(PPLD.TC_BILL_RATE_OVERRIDE,NVL(PPLD.TC_STD_BILL_RATE,0)),0,TO_NUMBER(NULL),(PPLD.QUANTITY) * NVL(PPLD.TC_BILL_RATE_OVERRIDE,NVL(PPLD.TC_STD_BILL_RATE,0)))/ NULLIF(DECODE(NVL(PPLD.TC_BILL_RATE_OVERRIDE,NVL(PPLD.TC_STD_BILL_RATE,0)),0,TO_NUMBER(NULL),(PPLD.QUANTITY)),0) AS TC_BILL_RATE, TO_NUMBER(NULL) AS TC_BILL_RATE_ORIG, PPLD.TC_BRDND_COST, PPLD.TC_BRDND_COST AS TC_BRDND_COST_ORIG, DECODE(NVL(PPLD.TC_BRDND_COST_RATE_OVERRIDE,NVL(PPLD.TC_STD_BRDND_COST_RATE,0)),0,TO_NUMBER(NULL),(PPLD.QUANTITY) * NVL(PPLD.TC_BRDND_COST_RATE_OVERRIDE,NVL(PPLD.TC_STD_BRDND_COST_RATE,0)))/ NULLIF(DECODE(NVL(PPLD.TC_BRDND_COST_RATE_OVERRIDE,NVL(PPLD.TC_STD_BRDND_COST_RATE,0)),0,TO_NUMBER(NULL),(PPLD.QUANTITY)),0) AS TC_BRDND_COST_RATE, TO_NUMBER(NULL) AS TC_BRDND_COST_RATE_ORIG, TO_NUMBER(NULL) AS TC_CHANGE_BRDND_COST, TO_NUMBER(NULL) AS TC_CHANGE_RAW_COST, TO_NUMBER(NULL) AS TC_CHANGE_REVENUE, DECODE(SIGN(PPLD.END_DATE - PPV.ETC_START_DATE),-1,TO_NUMBER(NULL), NULLIF((NVL(PPLD.TC_BRDND_COST,0)-NVL(PPLD.TC_ACT_BRDND_COST,0)),0)) AS TC_ETC_BRDND_COST, TO_NUMBER(NULL) AS TC_ETC_BRDND_COST_ORIG, DECODE(SIGN(PPLD.END_DATE - PPV.ETC_START_DATE),-1,TO_NUMBER(NULL), NULLIF((NVL(PPLD.TC_RAW_COST,0)-NVL(PPLD.TC_ACT_RAW_COST,0)),0)) AS TC_ETC_RAW_COST, TO_NUMBER(NULL) AS TC_ETC_RAW_COST_ORIG, DECODE(SIGN(PPLD.END_DATE - PPV.ETC_START_DATE),-1,TO_NUMBER(NULL), NULLIF((NVL(PPLD.TC_REVENUE,0)-NVL(PPLD.TC_ACT_REVENUE,0)),0)) AS TC_ETC_REVENUE, TO_NUMBER(NULL) AS TC_ETC_REVENUE_ORIG, NULLIF(DECODE(PPO.MARGIN_DERIVED_FROM_CODE,'B',TO_NUMBER(NVL(PPLD.TC_REVENUE,0) - NVL(PPLD.TC_BRDND_COST,0)),TO_NUMBER(NVL(PPLD.TC_REVENUE,0) - NVL(PPLD.TC_RAW_COST,0))),0) AS TC_MARGIN, ((DECODE(PPO.MARGIN_DERIVED_FROM_CODE,'B',TO_NUMBER(NVL(PPLD.TC_REVENUE,0) - NVL(PPLD.TC_BRDND_COST,0)),TO_NUMBER(NVL(PPLD.TC_REVENUE,0) - NVL(PPLD.TC_RAW_COST,0))))/(DECODE(PPLD.TC_REVENUE,0,TO_NUMBER(NULL),PPLD.TC_REVENUE))) AS TC_MARGIN_PCT, PPLD.TC_RAW_COST, PPLD.TC_RAW_COST AS TC_RAW_COST_ORIG, DECODE(NVL(PPLD.TC_RAW_COST_RATE_OVERRIDE,NVL(PPLD.TC_STD_RAW_COST_RATE,0)),0,TO_NUMBER(NULL),(PPLD.QUANTITY) * NVL(PPLD.TC_RAW_COST_RATE_OVERRIDE,NVL(PPLD.TC_STD_RAW_COST_RATE,0)))/ NULLIF(DECODE(NVL(PPLD.TC_RAW_COST_RATE_OVERRIDE,NVL(PPLD.TC_STD_RAW_COST_RATE,0)),0,TO_NUMBER(NULL),(PPLD.QUANTITY)),0) AS TC_RAW_COST_RATE, TO_NUMBER(NULL) AS TC_RAW_COST_RATE_ORIG, PPLD.TC_REVENUE, PPLD.TC_REVENUE AS TC_REVENUE_ORIG, PUM.UNIT_OF_MEASURE, PPE.UNIT_OF_MEASURE UOM_CODE, PPE.SPREAD_CURVE_ID, PPLD.REQ_QUANTITY, PPLD.PO_QUANTITY, PPLD.SI_QUANTITY, PPLD.EXT_QUANTITY, PPLD.TC_REQ_RAW_COST, PPLD.TC_PO_RAW_COST, PPLD.TC_SI_RAW_COST, PPLD.TC_EXT_RAW_COST, PPLD.TC_REQ_BRDND_COST, PPLD.TC_PO_BRDND_COST, PPLD.TC_SI_BRDND_COST, PPLD.TC_EXT_BRDND_COST, PPLD.PFC_PO_RAW_COST, PPLD.PC_EXT_BRDND_COST, PPLD.PC_EXT_RAW_COST, PPLD.PC_PO_BRDND_COST, PPLD.PC_REQ_BRDND_COST, PPLD.PC_REQ_RAW_COST, PPLD.PC_SI_RAW_COST, DECODE(PPLD.ACT_QUANTITY,NULL,TO_NUMBER(NULL),0,TO_NUMBER(NULL),PPLD.PFC_ACT_REVENUE/PPLD.ACT_QUANTITY) AS PFC_ACT_BILL_RATE, DECODE(PPLD.ACT_QUANTITY,NULL,TO_NUMBER(NULL),0,TO_NUMBER(NULL),PPLD.PFC_ACT_BRDND_COST/PPLD.ACT_QUANTITY) AS PFC_ACT_BRDND_COST_RATE, DECODE(PPLD.ACT_QUANTITY,NULL,TO_NUMBER(NULL),0,TO_NUMBER(NULL),PPLD.PC_ACT_REVENUE/PPLD.ACT_QUANTITY) AS PC_ACT_BILL_RATE, DECODE(PPLD.ACT_QUANTITY,NULL,TO_NUMBER(NULL),0,TO_NUMBER(NULL),PPLD.PC_ACT_BRDND_COST/PPLD.ACT_QUANTITY) AS PC_ACT_BRDND_COST_RATE, PPLD.PFC_EXT_BRDND_COST, PPLD.PFC_PO_BRDND_COST, PPLD.PFC_REQ_BRDND_COST, PPLD.PFC_REQ_RAW_COST, PPLD.PFC_SI_BRDND_COST, PPLD.PC_PO_RAW_COST, PPLD.PFC_SI_RAW_COST, PPLD.PC_SI_BRDND_COST, PPLD.PFC_EXT_RAW_COST, PPLD.TC_STD_BILL_RATE, PPLD.TC_STD_BRDND_COST_RATE, PPLD.TC_STD_RAW_COST_RATE, PPLD.TC_STD_BRDND_MULTIPLIER, PPLD.TC_MARKUP_PERCENT, FND_GLOBAL.SESSION_ID AS SESSION_ID, PPLD.TO_QUANTITY, PPLD.TC_TO_RAW_COST, PPLD.TC_TO_BRDND_COST, PPLD.RCPT_QUANTITY, PPLD.TC_RCPT_RAW_COST, PPLD.TC_RCPT_BRDND_COST, PPLD.PC_TO_RAW_COST, PPLD.PC_TO_BRDND_COST, PPLD.PFC_TO_RAW_COST, PPLD.PFC_TO_BRDND_COST, PPLD.PC_RCPT_RAW_COST, PPLD.PC_RCPT_BRDND_COST, PPLD.PFC_RCPT_RAW_COST, PPLD.PFC_RCPT_BRDND_COST, PPLD.MANUAL_SPREAD_FLAG FROM PJO_PLAN_LINE_DETAILS PPLD, PJO_PLANNING_ELEMENTS PPE, PJO_PLAN_LINES PPL, PJO_PLAN_VERSIONS_B PPV, PJO_PLANNING_OPTIONS PPO, PJF_PROJECTS_ALL_B PPA, PJF_UNITS_OF_MEASURE_V PUM WHERE PPV.PLAN_VERSION_ID = PPO.PLAN_VERSION_ID AND PPV.PLAN_VERSION_ID = PPE.PLAN_VERSION_ID AND PPE.PLANNING_ELEMENT_ID = PPL.PLANNING_ELEMENT_ID AND PPL.PLAN_VERSION_ID = PPV.PLAN_VERSION_ID AND PPLD.PLAN_VERSION_ID(+) = PPL.PLAN_VERSION_ID AND PPLD.PLANNING_ELEMENT_ID(+) = PPL.PLANNING_ELEMENT_ID AND PPLD.TXN_CURRENCY_CODE(+) = PPL.TXN_CURRENCY_CODE AND PPE.UNIT_OF_MEASURE = PUM.UOM_CODE(+) AND PPV.PROJECT_ID = PPA.PROJECT_ID