1. Tables and Views for Project Management
  2. PJO_DIS_NON_PD_DETAILS_ALL_V

PJO_DIS_NON_PD_DETAILS_ALL_V

Details

  • Schema: FUSION

  • Object owner: PJO

  • Object type: VIEW

Columns

Name

PLAN_LINE_ID

PLANNING_ELEMENT_ID

TXN_CURRENCY_CODE

PLAN_VERSION_ID

PLANNING_ELEMENT_ID1

TASK_ID

RBS_ELEMENT_ID

SPREAD_CURVE_ID

PLANNING_START_DATE

PLANNING_END_DATE

UNIT_OF_MEASURE

UOM_CODE

OBJECT_ID1

RA_TASK_DATES_SAME

UNPLANNED_FLAG

PROJECT_ID

ELEMENT_NUMBER

PROJ_ELEMENT_ID

OBJECT_VERSION_NUMBER

NAME

PROJ_ELEMENT_ID1

ALIAS

RBS_ELEMENT_ID1

TRANS_TASK_NAME

TRANS_TASK_NUMBER

TRANS_RESOURCE_ALIAS

TRANS_CURRENCY_CODE

TRANS_SPREAD_CURVE_NAME

PLAN_TYPE_ID

TOTAL_QUANTITY

TOTAL_TC_BRDND_COST

TOTAL_TC_RAW_COST

PLAN_VERSION_ID1

TOTAL_TC_REVENUE

TC_STD_BILL_RATE

TC_STD_BRDND_COST_RATE

TC_STD_RAW_COST_RATE

QUANTITY_ORIGINAL_BASELINE

RAWCOST_ORIGINAL_BASELINE

QUANTITY_CURRENT_BASELINE

RAWCOST_CURRENT_BASELINE

BRDNDCOST_ORIGINAL_BASELINE

BRDNDCOST_CURRENT_BASELINE

REVENUE_CURRENT_BASELINE

REVENUE_ORIGINAL_BASELINE

TC_MARGIN

TC_MARGIN_ORIG_BASE

TC_MARGIN_CURRENT_BASE

TC_ORIG_BASELINE

TC_CURRENT_BASE_LINE

PC_COST_RATE_DATE_TYPE

PC_COST_RATE_DATE

PC_COST_RATE_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

PC_RAW_COST_ORIG_BASE

PC_RAW_COST_CURRENT_BASE

PC_RAW_COST

PFC_RAW_COST_ORIG_BASE

PFC_RAW_COST_CURRENT_BASE

PFC_RAW_COST

PC_BRDND_COST_ORIG_BASE

PC_BRDND_COST_CURRENT_BASE

PC_BRDND_COST

PC_REVENUE_ORIG_BASE

PC_REVENUE_CURRENT_BASE

PC_REVENUE

PFC_REVENUE_ORIG_BASE

PFC_REVENUE_CURRENT_BASE

PFC_REVENUE

PC_MARGIN_ORIG_BASE

PC_MARGIN_CURRENT_BASE

PC_MARGIN

PFC_MARGIN_ORIG_BASE

PFC_MARGIN_CURRENT_BASE

PFC_MARGIN

TRANSRESOURCECLASSNAME

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

PFC_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

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

ETC_QUANTITY

TC_ETC_RAW_COST

PC_ETC_RAW_COST

PFC_ETC_RAW_COST

TC_ETC_BRDND_COST

PC_ETC_BRDND_COST

PFC_ETC_BRDND_COST

TC_ETC_REVENUE

PC_ETC_REVENUE

PFC_ETC_REVENUE

TC_ACT_RAW_COST_RATE

PC_ACT_RAW_COST_RATE

PFC_ACT_RAW_COST_RATE

TC_ACT_BRDND_COST_RATE

PC_ACT_BRDND_COST_RATE

PFC_ACT_BRDND_COST_RATE

TC_ACT_BILL_RATE

PC_ACT_BILL_RATE

PFC_ACT_BILL_RATE

TC_STD_BRDND_MULTIPLIER

TC_ACT_MARGIN

PC_ACT_MARGIN

PFC_ACT_MARGIN

TC_MARGIN_PCT

PC_MARGIN_PCT

PFC_MARGIN_PCT

QUANTITY

TC_RAW_COST

TC_BRDND_COST

TC_REVENUE

TC_RAWCOST_EFFEC_RATE

TC_BRDNDCOST_EFFEC_RATE

TC_BRDNDCOST_EFFEC_MULTIPLIER

TC_REVENUE_EFFEC_RATE

PFC_BRDND_COST_ORIG_BASE

PFC_BRDND_COST_CURRENT_BASE

PFC_BRDND_COST

TC_MARGIN_ORIG_PCT

TC_MARGIN_CURR_PCT

RC_TOTAL_COMMITMENTS

BC_TOTAL_COMMITMENTS

PC_RAW_COST_TOTAL_COMMITMENTS

PFC_RAW_COST_TOTAL_COMMITMENTS

PC_BRDND_COMMITMENTS

PFC_BRDND_COMMITMENTS

MARGIN_TOTAL_COMMITMENTS

ETC_MARGIN

MARGIN_PER_TOTAL_COMMITMENTS

PC_ACT_MARGIN_PCT

ETC_MARGIN_PCT

PFC_ACT_MARGIN_PCT

PC_MARGIN_TOTAL_COMMITMENTS

PC_MARGIN_ETC

PFC_MARGIN_TOTAL_COMMITMENTS

PFC_ETC_MARGIN

PC_COST_EXCHANGE_RATE

PFC_COST_EXCHANGE_RATE

PFC_REV_EXCHANGE_RATE

PC_REV_EXCHANGE_RATE

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

PRV_FCST_ACT_QTY

PRV_FCST_TOT_QTY

PRV_FCST_ETC_QTY

PRV_FCST_TC_ACT_RAW_COST

PRV_FCST_TC_RAW_COST

PRV_FCST_TC_ETC_RAW_COST

PRV_FCST_TC_ACT_BRDND_COST

PRV_FCST_TC_BRDND_COST

PRV_FCST_TC_ETC_BRDND_COST

PRV_FCST_TC_ACT_REVENUE

PRV_FCST_TC_REVENUE

PRV_FCST_TC_ETC_REVENUE

PRV_FCST_TC_ACT_MARGIN

PRV_FCST_TC_MARGIN

PRV_FCST_TC_ETC_MARGIN

PRV_FCST_TC_MARGIN_PCT

PRV_FCST_TC_ACT_MARGIN_PCT

PRV_FCST_TC_ETC_MARGIN_PCT

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

Query

SQL_Statement

SELECT DesktopDisplayNonPeriodicEO.PLAN_LINE_ID,

DesktopDisplayNonPeriodicEO.PLANNING_ELEMENT_ID,

DesktopDisplayNonPeriodicEO.TXN_CURRENCY_CODE,

DesktopDisplayNonPeriodicEO.PLAN_VERSION_ID,

DesktopDisplayNonPeriodicEO.PLANNING_ELEMENT_ID1,

DesktopDisplayNonPeriodicEO.TASK_ID,

DesktopDisplayNonPeriodicEO.RBS_ELEMENT_ID,

DesktopDisplayNonPeriodicEO.SPREAD_CURVE_ID,

DesktopDisplayNonPeriodicEO.PLANNING_START_DATE,

DesktopDisplayNonPeriodicEO.PLANNING_END_DATE,

DesktopDisplayNonPeriodicEO.UNIT_OF_MEASURE,

DesktopDisplayNonPeriodicEO.UOM_CODE,

DesktopDisplayNonPeriodicEO.OBJECT_ID1,

DesktopDisplayNonPeriodicEO.RA_TASK_DATES_SAME,

DesktopDisplayNonPeriodicEO.UNPLANNED_FLAG,

DesktopDisplayNonPeriodicEO.PROJECT_ID,

TaskStructurePEO.ELEMENT_NUMBER,

TaskStructurePEO.PROJ_ELEMENT_ID,

TaskStructurePEO.OBJECT_VERSION_NUMBER,

TaskStructurePEO.NAME,

TaskStructurePEO.PROJ_ELEMENT_ID AS PROJ_ELEMENT_ID1,

ProjResBrkdwnStructElePEO.ALIAS,

ProjResBrkdwnStructElePEO.RBS_ELEMENT_ID AS RBS_ELEMENT_ID1,

(TaskStructurePEO.NAME) AS TRANS_TASK_NAME,

(TaskStructurePEO.ELEMENT_NUMBER) AS TRANS_TASK_NUMBER,

(ProjResBrkdwnStructElePEO.ALIAS) AS TRANS_RESOURCE_ALIAS,

(DesktopDisplayNonPeriodicEO.TXN_CURRENCY_CODE) AS TRANS_CURRENCY_CODE,

(SpreadCurveEO.NAME) AS TRANS_SPREAD_CURVE_NAME,

DesktopDisplayNonPeriodicEO.PLAN_TYPE_ID,

DesktopDisplayNonPeriodicEO.TOTAL_QUANTITY,

DesktopDisplayNonPeriodicEO.TOTAL_TC_BRDND_COST,

DesktopDisplayNonPeriodicEO.TOTAL_TC_RAW_COST,

DesktopDisplayNonPeriodicEO.PLAN_VERSION_ID1,

DesktopDisplayNonPeriodicEO.TOTAL_TC_REVENUE,

DesktopDisplayNonPeriodicEO.TC_STD_BILL_RATE,

DesktopDisplayNonPeriodicEO.TC_STD_BRDND_COST_RATE,

DesktopDisplayNonPeriodicEO.TC_STD_RAW_COST_RATE,

to_number(null) AS QUANTITY_ORIGINAL_BASELINE,

to_number(null) AS RAWCOST_ORIGINAL_BASELINE,

to_number(null) AS QUANTITY_CURRENT_BASELINE,

to_number(null) AS RAWCOST_CURRENT_BASELINE,

to_number(null) AS BRDNDCOST_ORIGINAL_BASELINE,

to_number(null) AS BRDNDCOST_CURRENT_BASELINE,

to_number(null) AS REVENUE_CURRENT_BASELINE,

to_number(null) AS REVENUE_ORIGINAL_BASELINE,

DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B',to_number((nvl(DesktopDisplayNonPeriodicEO.TOTAL_tc_revenue,0)) - (nvl(DesktopDisplayNonPeriodicEO.total_tc_brdnd_cost,0))),

to_number((nvl(DesktopDisplayNonPeriodicEO.total_tc_revenue,0)) - (nvl(DesktopDisplayNonPeriodicEO.total_tc_raw_cost,0)))) as TC_MARGIN,

to_number(null) AS TC_MARGIN_ORIG_BASE,

to_number(null) AS TC_MARGIN_CURRENT_BASE,

null TC_ORIG_BASELINE,

null TC_CURRENT_BASE_LINE,

DesktopDisplayNonPeriodicEO.PC_COST_RATE_DATE_TYPE,

DesktopDisplayNonPeriodicEO.PC_COST_RATE_DATE,

DesktopDisplayNonPeriodicEO.PC_COST_RATE_TYPE,

DesktopDisplayNonPeriodicEO.PC_REV_RATE_DATE_TYPE,

DesktopDisplayNonPeriodicEO.PC_REV_RATE_DATE,

DesktopDisplayNonPeriodicEO.PC_REV_RATE_TYPE,

DesktopDisplayNonPeriodicEO.PFC_COST_RATE_DATE_TYPE,

DesktopDisplayNonPeriodicEO.PFC_COST_RATE_DATE,

DesktopDisplayNonPeriodicEO.PFC_COST_RATE_TYPE,

DesktopDisplayNonPeriodicEO.PFC_REV_RATE_DATE_TYPE,

DesktopDisplayNonPeriodicEO.PFC_REV_RATE_DATE,

DesktopDisplayNonPeriodicEO.PFC_REV_RATE_TYPE,

to_number(null) AS PC_RAW_COST_ORIG_BASE,

to_number(null) AS PC_RAW_COST_CURRENT_BASE,

decode((DesktopDisplayNonPeriodicEO.pc_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_raw_cost)) as PC_RAW_COST,

to_number(null) AS PFC_RAW_COST_ORIG_BASE,

to_number(null) AS PFC_RAW_COST_CURRENT_BASE,

decode((DesktopDisplayNonPeriodicEO.pfc_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_raw_cost)) as PFC_RAW_COST,

to_number(null) AS PC_BRDND_COST_ORIG_BASE,

to_number(null) AS PC_BRDND_COST_CURRENT_BASE,

decode((DesktopDisplayNonPeriodicEO.pc_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_brdnd_cost)) as PC_BRDND_COST,

to_number(null) AS PC_REVENUE_ORIG_BASE,

to_number(null) AS PC_REVENUE_CURRENT_BASE,

decode((DesktopDisplayNonPeriodicEO.pc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_revenue)) as PC_REVENUE,

to_number(null) AS PFC_REVENUE_ORIG_BASE,

to_number(null) AS PFC_REVENUE_CURRENT_BASE,

decode((DesktopDisplayNonPeriodicEO.pfc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_revenue)) as PFC_REVENUE,

to_number(null) AS PC_MARGIN_ORIG_BASE,

to_number(null) AS PC_MARGIN_CURRENT_BASE,

DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B', to_number((nvl(DesktopDisplayNonPeriodicEO.pfc_revenue,0)) - (nvl(DesktopDisplayNonPeriodicEO.pfc_brdnd_cost,0))),to_number((nvl(DesktopDisplayNonPeriodicEO.pfc_revenue,0)) - (nvl(DesktopDisplayNonPeriodicEO.pfc_raw_cost,0)))) as PC_MARGIN,

to_number(null) AS PFC_MARGIN_ORIG_BASE,

to_number(null) AS PFC_MARGIN_CURRENT_BASE,

DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B', to_number((nvl(DesktopDisplayNonPeriodicEO.pfc_revenue,0)) - (nvl(DesktopDisplayNonPeriodicEO.pfc_brdnd_cost,0))),to_number((nvl(DesktopDisplayNonPeriodicEO.pfc_revenue,0)) - (nvl(DesktopDisplayNonPeriodicEO.pfc_raw_cost,0)))) as PFC_MARGIN,

PjfResourceClassesVl.NAME AS TransResourceClassName,

decode((DesktopDisplayNonPeriodicEO.req_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.req_quantity)) as REQ_QUANTITY,

decode((DesktopDisplayNonPeriodicEO.tc_req_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_req_raw_cost)) as TC_REQ_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pc_req_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_req_raw_cost)) as PC_REQ_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_req_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_req_raw_cost)) as PFC_REQ_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.tc_req_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_req_brdnd_cost)) as TC_REQ_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pc_req_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_req_brdnd_cost)) as PC_REQ_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_req_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_req_brdnd_cost)) as PFC_REQ_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.po_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.po_quantity)) as PO_QUANTITY,

decode((DesktopDisplayNonPeriodicEO.tc_po_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_po_raw_cost)) as TC_PO_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pc_po_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_po_raw_cost)) as PC_PO_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pc_po_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_po_raw_cost)) as PFC_PO_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.tc_po_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_po_brdnd_cost)) as TC_PO_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pc_po_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_po_brdnd_cost)) as PC_PO_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_po_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_po_brdnd_cost)) as PFC_PO_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.si_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.si_quantity)) as SI_QUANTITY,

decode((DesktopDisplayNonPeriodicEO.tc_si_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_si_raw_cost)) as TC_SI_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pc_si_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_si_raw_cost)) as PC_SI_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_si_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_si_raw_cost)) as PFC_SI_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.tc_si_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_si_brdnd_cost)) as TC_SI_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pc_si_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_si_brdnd_cost)) as PC_SI_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_si_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_si_brdnd_cost)) as PFC_SI_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.ext_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.ext_quantity)) as EXT_QUANTITY,

decode((DesktopDisplayNonPeriodicEO.tc_ext_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_ext_raw_cost)) as TC_EXT_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pc_ext_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_ext_raw_cost)) as PC_EXT_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_ext_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_ext_raw_cost)) as PFC_EXT_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.tc_ext_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_ext_brdnd_cost)) as TC_EXT_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pc_ext_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_ext_brdnd_cost)) as PC_EXT_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_ext_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_ext_brdnd_cost)) as PFC_EXT_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.act_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.act_quantity)) as ACT_QUANTITY,

decode((DesktopDisplayNonPeriodicEO.tc_act_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_act_raw_cost)) as TC_ACT_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pc_act_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_act_raw_cost)) as PC_ACT_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_act_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_act_raw_cost)) as PFC_ACT_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.tc_act_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_act_brdnd_cost)) as TC_ACT_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pc_act_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_act_brdnd_cost)) as PC_ACT_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_act_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_act_brdnd_cost)) as PFC_ACT_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.tc_act_revenue),0,to_number(null),(DesktopDisplayNonPeriodicEO.tc_act_revenue)) as TC_ACT_REVENUE,

decode((DesktopDisplayNonPeriodicEO.pc_act_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_act_revenue)) as PC_ACT_REVENUE,

decode((DesktopDisplayNonPeriodicEO.pfc_act_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_act_revenue)) as PFC_ACT_REVENUE,

decode((NVL((decode((DesktopDisplayNonPeriodicEO.total_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_quantity))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.total_act_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_act_quantity))), 0)), 0, to_number(null), (NVL((decode((DesktopDisplayNonPeriodicEO.total_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_quantity))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.total_act_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_act_quantity))), 0))) as ETC_QUANTITY,

decode((NVL((decode((DesktopDisplayNonPeriodicEO.total_tc_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_tc_raw_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.total_tc_act_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_tc_act_raw_cost))), 0)), 0, to_number(null), (NVL((decode((DesktopDisplayNonPeriodicEO.total_tc_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_tc_raw_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.total_tc_act_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_tc_act_raw_cost))),0))) as TC_ETC_RAW_COST,

decode((NVL((decode((DesktopDisplayNonPeriodicEO.pc_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_raw_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pc_act_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_act_raw_cost))), 0)), 0, to_number(null), (NVL((decode((DesktopDisplayNonPeriodicEO.pc_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_raw_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pc_act_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_act_raw_cost))),0))) as PC_ETC_RAW_COST,

decode((NVL((decode((DesktopDisplayNonPeriodicEO.pfc_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_raw_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pfc_act_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_act_raw_cost))), 0)), 0, to_number(null), (NVL((decode((DesktopDisplayNonPeriodicEO.pfc_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_raw_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pfc_act_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_act_raw_cost))),0))) as PFC_ETC_RAW_COST,

decode((NVL((decode((DesktopDisplayNonPeriodicEO.total_tc_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_tc_brdnd_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.total_tc_act_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_tc_act_brdnd_cost))), 0)), 0, to_number(null), (NVL((decode((DesktopDisplayNonPeriodicEO.total_tc_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_tc_brdnd_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.total_tc_act_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.total_tc_act_brdnd_cost))),0))) as TC_ETC_BRDND_COST,

decode((NVL((decode((DesktopDisplayNonPeriodicEO.pc_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_brdnd_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pc_act_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_act_brdnd_cost))), 0)), 0, to_number(null), (NVL((decode((DesktopDisplayNonPeriodicEO.pc_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_brdnd_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pc_act_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_act_brdnd_cost))),0))) as PC_ETC_BRDND_COST,

decode((NVL((decode((DesktopDisplayNonPeriodicEO.pfc_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_brdnd_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pfc_act_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_act_brdnd_cost))), 0)), 0, to_number(null), (NVL((decode((DesktopDisplayNonPeriodicEO.pfc_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_brdnd_cost))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pfc_act_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_act_brdnd_cost))),0))) as PFC_ETC_BRDND_COST,

decode((NVL((decode((DesktopDisplayNonPeriodicEO.tc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_revenue))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.tc_act_revenue),0,to_number(null),(DesktopDisplayNonPeriodicEO.tc_act_revenue))), 0)), 0, to_number(null), (NVL((decode((DesktopDisplayNonPeriodicEO.tc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_revenue))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.tc_act_revenue),0,to_number(null),(DesktopDisplayNonPeriodicEO.tc_act_revenue))),0))) as TC_ETC_REVENUE,

decode((NVL((decode((DesktopDisplayNonPeriodicEO.pc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_revenue))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pc_act_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_act_revenue))), 0)), 0, to_number(null), (NVL((decode((DesktopDisplayNonPeriodicEO.pc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_revenue))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pc_act_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_act_revenue))),0))) as PC_ETC_REVENUE,

decode((NVL((decode((DesktopDisplayNonPeriodicEO.pfc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_revenue))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pfc_act_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_act_revenue))), 0)), 0, to_number(null), (NVL((decode((DesktopDisplayNonPeriodicEO.pfc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_revenue))), 0) - NVL((decode((DesktopDisplayNonPeriodicEO.pfc_act_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_act_revenue))),0))) as PFC_ETC_REVENUE,

DECODE ( (DesktopDisplayNonPeriodicEO.act_quantity),0, TO_NUMBER (NULL),NULL, TO_NUMBER (NULL), (DECODE ( (DesktopDisplayNonPeriodicEO.tc_act_raw_cost),0, TO_NUMBER (NULL), (DesktopDisplayNonPeriodicEO.tc_act_raw_cost))/ (DesktopDisplayNonPeriodicEO.act_quantity))) as TC_ACT_RAW_COST_RATE,

DECODE ( (DesktopDisplayNonPeriodicEO.act_quantity),0, TO_NUMBER (NULL),NULL, TO_NUMBER (NULL), (DECODE ( (DesktopDisplayNonPeriodicEO.pc_act_raw_cost),0, TO_NUMBER (NULL), (DesktopDisplayNonPeriodicEO.pc_act_raw_cost))/ (DesktopDisplayNonPeriodicEO.act_quantity))) as PC_ACT_RAW_COST_RATE,

DECODE ( (DesktopDisplayNonPeriodicEO.act_quantity),0, TO_NUMBER (NULL),NULL, TO_NUMBER (NULL), (DECODE ( (DesktopDisplayNonPeriodicEO.pfc_act_raw_cost),0, TO_NUMBER (NULL), (DesktopDisplayNonPeriodicEO.pfc_act_raw_cost))/ (DesktopDisplayNonPeriodicEO.act_quantity))) as PFC_ACT_RAW_COST_RATE,

DECODE ( (DesktopDisplayNonPeriodicEO.act_quantity),0, TO_NUMBER (NULL),NULL, TO_NUMBER (NULL), (DECODE ( (DesktopDisplayNonPeriodicEO.tc_act_brdnd_cost),0, TO_NUMBER (NULL), (DesktopDisplayNonPeriodicEO.tc_act_brdnd_cost))/ (DesktopDisplayNonPeriodicEO.act_quantity))) as TC_ACT_BRDND_COST_RATE,

DECODE ( (DesktopDisplayNonPeriodicEO.act_quantity),0, TO_NUMBER (NULL),NULL, TO_NUMBER (NULL), (DECODE ( (DesktopDisplayNonPeriodicEO.pc_act_brdnd_cost),0, TO_NUMBER (NULL), (DesktopDisplayNonPeriodicEO.pc_act_brdnd_cost))/ (DesktopDisplayNonPeriodicEO.act_quantity))) as PC_ACT_BRDND_COST_RATE,

DECODE ( (DesktopDisplayNonPeriodicEO.act_quantity),0, TO_NUMBER (NULL),NULL, TO_NUMBER (NULL), (DECODE ( (DesktopDisplayNonPeriodicEO.pfc_act_brdnd_cost),0, TO_NUMBER (NULL), (DesktopDisplayNonPeriodicEO.pfc_act_brdnd_cost))/ (DesktopDisplayNonPeriodicEO.act_quantity))) as PFC_ACT_BRDND_COST_RATE,

DECODE ( (DesktopDisplayNonPeriodicEO.act_quantity),0, TO_NUMBER (NULL),NULL, TO_NUMBER (NULL),(DECODE ( (DesktopDisplayNonPeriodicEO.tc_act_revenue),0, TO_NUMBER (NULL), (DesktopDisplayNonPeriodicEO.tc_act_revenue))/ (DesktopDisplayNonPeriodicEO.act_quantity))) as TC_ACT_BILL_RATE,

DECODE ( (DesktopDisplayNonPeriodicEO.act_quantity),0, TO_NUMBER (NULL),NULL, TO_NUMBER (NULL),(DECODE ( (DesktopDisplayNonPeriodicEO.pc_act_revenue),0, TO_NUMBER (NULL), (DesktopDisplayNonPeriodicEO.pc_act_revenue))/ (DesktopDisplayNonPeriodicEO.act_quantity))) as PC_ACT_BILL_RATE,

DECODE ( (DesktopDisplayNonPeriodicEO.act_quantity),0, TO_NUMBER (NULL),NULL, TO_NUMBER (NULL),(DECODE ( (DesktopDisplayNonPeriodicEO.pfc_act_revenue),0, TO_NUMBER (NULL), (DesktopDisplayNonPeriodicEO.pfc_act_revenue))/ (DesktopDisplayNonPeriodicEO.act_quantity))) as PFC_ACT_BILL_RATE,

(PlanLineEO.TC_AVG_STD_BRDND_MULTIPLIER) as TC_STD_BRDND_MULTIPLIER,

DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B',to_number((DesktopDisplayNonPeriodicEO.tc_act_revenue) - (DesktopDisplayNonPeriodicEO.tc_act_brdnd_cost)),to_number((DesktopDisplayNonPeriodicEO.tc_act_revenue) - (DesktopDisplayNonPeriodicEO.tc_act_raw_cost))) as TC_ACT_MARGIN,

DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B',to_number((DesktopDisplayNonPeriodicEO.pc_act_revenue) - (DesktopDisplayNonPeriodicEO.pc_act_brdnd_cost)),to_number((DesktopDisplayNonPeriodicEO.pc_act_revenue) - (DesktopDisplayNonPeriodicEO.pc_act_raw_cost))) as PC_ACT_MARGIN,

DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B',to_number((DesktopDisplayNonPeriodicEO.pfc_act_revenue) - (DesktopDisplayNonPeriodicEO.pfc_act_brdnd_cost)),to_number((DesktopDisplayNonPeriodicEO.pfc_act_revenue) - (DesktopDisplayNonPeriodicEO.pfc_act_raw_cost))) as PFC_ACT_MARGIN,

(decode(nvl((DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B',to_number((DesktopDisplayNonPeriodicEO.tc_revenue) - (DesktopDisplayNonPeriodicEO.tc_brdnd_cost)),to_number((DesktopDisplayNonPeriodicEO.tc_revenue) - (DesktopDisplayNonPeriodicEO.tc_raw_cost)))), 0),0, to_number(NULL), (DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B',to_number((DesktopDisplayNonPeriodicEO.tc_revenue) - (DesktopDisplayNonPeriodicEO.tc_brdnd_cost)),to_number((DesktopDisplayNonPeriodicEO.tc_revenue) - (DesktopDisplayNonPeriodicEO.tc_raw_cost))))) / decode(nvl((decode((DesktopDisplayNonPeriodicEO.tc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_revenue))), 0),0, to_number(NULL), (decode((DesktopDisplayNonPeriodicEO.tc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_revenue))))) as TC_MARGIN_PCT,

(decode(nvl((DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B', to_number((DesktopDisplayNonPeriodicEO.pc_revenue) - (DesktopDisplayNonPeriodicEO.pc_brdnd_cost)),to_number((DesktopDisplayNonPeriodicEO.pc_revenue) - (DesktopDisplayNonPeriodicEO.pc_raw_cost)))), 0),0, to_number(NULL), (DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B', to_number((DesktopDisplayNonPeriodicEO.pc_revenue) - (DesktopDisplayNonPeriodicEO.pc_brdnd_cost)),to_number((DesktopDisplayNonPeriodicEO.pc_revenue) - (DesktopDisplayNonPeriodicEO.pc_raw_cost))))) / decode(nvl((decode((DesktopDisplayNonPeriodicEO.pc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_revenue))), 0),0, to_number(NULL), (decode((DesktopDisplayNonPeriodicEO.pc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_revenue))))) as PC_MARGIN_PCT,

(decode(nvl((DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B', to_number((DesktopDisplayNonPeriodicEO.pfc_revenue) - (DesktopDisplayNonPeriodicEO.pfc_brdnd_cost)),to_number((DesktopDisplayNonPeriodicEO.pfc_revenue) - (DesktopDisplayNonPeriodicEO.pfc_raw_cost)))), 0),0, to_number(NULL), (DECODE(ppd.MARGIN_DERIVED_FROM_CODE,'B', to_number((DesktopDisplayNonPeriodicEO.pfc_revenue) - (DesktopDisplayNonPeriodicEO.pfc_brdnd_cost)),to_number((DesktopDisplayNonPeriodicEO.pfc_revenue) - (DesktopDisplayNonPeriodicEO.pfc_raw_cost))))) / decode(nvl((decode((DesktopDisplayNonPeriodicEO.pfc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_revenue))), 0),0, to_number(NULL), (decode((DesktopDisplayNonPeriodicEO.pfc_revenue),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_revenue))))) as PFC_MARGIN_PCT,

DesktopDisplayNonPeriodicEO.quantity,

DesktopDisplayNonPeriodicEO.tc_raw_cost,

DesktopDisplayNonPeriodicEO.tc_brdnd_cost,

DesktopDisplayNonPeriodicEO.tc_revenue,

nvl(PlanLineEO.tc_raw_cost_rate_override,PlanLineEO.tc_average_raw_cost_rate) as TC_RAWCOST_EFFEC_RATE,

nvl(PlanLineEO.tc_brdnd_cost_rate_override,PlanLineEO.tc_average_brdnd_cost_rate) as TC_BRDNDCOST_EFFEC_RATE,

/*DECODE(PlanLineEO.TOTAL_TC_RAW_COST,NULL,NULL,0,NULL,DECODE(PlanLineEO.TOTAL_TC_BRDND_COST,NULL,NULL,(PlanLineEO.TOTAL_TC_BRDND_COST/PlanLineEO.TOTAL_TC_RAW_COST)-1)) as TC_BRDNDCOST_EFFEC_MULTIPLIER ,*/

case when (DECODE(PlanLineEO.TOTAL_TC_RAW_COST,NULL,NULL,0,NULL,DECODE(PlanLineEO.TOTAL_TC_BRDND_COST,NULL,NULL,(PlanLineEO.TOTAL_TC_BRDND_COST/PlanLineEO.TOTAL_TC_RAW_COST)-1))

) < 0 then

null

else

DECODE(PlanLineEO.TOTAL_TC_RAW_COST,NULL,NULL,0,NULL,DECODE(PlanLineEO.TOTAL_TC_BRDND_COST,NULL,NULL,(PlanLineEO.TOTAL_TC_BRDND_COST/PlanLineEO.TOTAL_TC_RAW_COST)-1))

end as TC_BRDNDCOST_EFFEC_MULTIPLIER ,

nvl(PlanLineEO.tc_bill_rate_override,PlanLineEO.tc_average_bill_rate) as TC_REVENUE_EFFEC_RATE,

to_number(null) AS PFC_BRDND_COST_ORIG_BASE,

to_number(null) AS PFC_BRDND_COST_CURRENT_BASE,

(decode((DesktopDisplayNonPeriodicEO.pfc_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_brdnd_cost))

) AS PFC_BRDND_COST,

to_number(null) as TC_MARGIN_ORIG_PCT,

to_number(null) as TC_MARGIN_CURR_PCT,

to_number(null) RC_TOTAL_COMMITMENTS,

to_number(null) BC_TOTAL_COMMITMENTS,

to_number(null) PC_RAW_COST_TOTAL_COMMITMENTS,

to_number(null) PFC_RAW_COST_TOTAL_COMMITMENTS,

to_number(null) PC_BRDND_COMMITMENTS,

to_number(null) PFC_BRDND_COMMITMENTS,

to_number(null) MARGIN_TOTAL_COMMITMENTS,

to_number(null) ETC_MARGIN,

to_number(null) MARGIN_PER_TOTAL_COMMITMENTS,

to_number(null) PC_ACT_MARGIN_PCT,

to_number(null) ETC_MARGIN_PCT,

to_number(null) PFC_ACT_MARGIN_PCT,

to_number(null) PC_MARGIN_TOTAL_COMMITMENTS,

to_number(null) PC_MARGIN_ETC,

to_number(null) PFC_MARGIN_TOTAL_COMMITMENTS,

to_number(null) PFC_ETC_MARGIN,

PjoPlanningCurrencies.PC_COST_EXCHANGE_RATE,

PjoPlanningCurrencies.PFC_COST_EXCHANGE_RATE,

PjoPlanningCurrencies.PFC_REV_EXCHANGE_RATE,

PjoPlanningCurrencies.PC_REV_EXCHANGE_RATE,

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

to_number(null) as PRV_FCST_ACT_QTY,

to_number(null) as PRV_FCST_TOT_QTY,

to_number(null) as PRV_FCST_ETC_QTY,

to_number(null) as PRV_FCST_TC_ACT_RAW_COST,

to_number(null) as PRV_FCST_TC_RAW_COST,

to_number(null) as PRV_FCST_TC_ETC_RAW_COST,

to_number(null) as PRV_FCST_TC_ACT_BRDND_COST,

to_number(null) as PRV_FCST_TC_BRDND_COST,

to_number(null) as PRV_FCST_TC_ETC_BRDND_COST,

to_number(null) as PRV_FCST_TC_ACT_REVENUE,

to_number(null) as PRV_FCST_TC_REVENUE,

to_number(null) as PRV_FCST_TC_ETC_REVENUE,

to_number(null) as PRV_FCST_TC_ACT_MARGIN,

to_number(null) as PRV_FCST_TC_MARGIN,

to_number(null) as PRV_FCST_TC_ETC_MARGIN,

to_number(null) as PRV_FCST_TC_MARGIN_PCT,

to_number(null) as PRV_FCST_TC_ACT_MARGIN_PCT,

to_number(null) as PRV_FCST_TC_ETC_MARGIN_PCT,

decode((DesktopDisplayNonPeriodicEO.to_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.to_quantity)) as TO_QUANTITY,

decode((DesktopDisplayNonPeriodicEO.tc_to_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_to_raw_cost)) as TC_TO_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pc_to_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_to_raw_cost)) as PC_TO_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_to_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_to_raw_cost)) as PFC_TO_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.tc_to_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_to_brdnd_cost)) as TC_TO_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pc_to_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_to_brdnd_cost)) as PC_TO_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_to_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_to_brdnd_cost)) as PFC_TO_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.rcpt_quantity),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.rcpt_quantity)) as RCPT_QUANTITY,

decode((DesktopDisplayNonPeriodicEO.tc_rcpt_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_rcpt_raw_cost)) as TC_RCPT_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pc_rcpt_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_rcpt_raw_cost)) as PC_RCPT_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_rcpt_raw_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_rcpt_raw_cost)) as PFC_RCPT_RAW_COST,

decode((DesktopDisplayNonPeriodicEO.tc_rcpt_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.tc_rcpt_brdnd_cost)) as TC_RCPT_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pc_rcpt_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pc_rcpt_brdnd_cost)) as PC_RCPT_BRDND_COST,

decode((DesktopDisplayNonPeriodicEO.pfc_rcpt_brdnd_cost),0,to_number(NULL),(DesktopDisplayNonPeriodicEO.pfc_rcpt_brdnd_cost)) as PFC_RCPT_BRDND_COST

FROM PJO_DIS_NON_PD_DETAILS_V DesktopDisplayNonPeriodicEO,

PJF_PROJ_ELEMENTS_VL TaskStructurePEO,

PJF_RBS_ELEMENTS_VL ProjResBrkdwnStructElePEO,

PJO_PLANNING_OPTIONS ppd,

PJF_RESOURCE_CLASSES_VL PjfResourceClassesVl,

PJO_PLANNING_CURRENCIES PjoPlanningCurrencies,

PJO_PLAN_LINES PlanLineEO,

PJO_SPREAD_CURVES_VL SpreadCurveEO

WHERE TaskStructurePEO.project_id=DesktopDisplayNonPeriodicEO.project_id

AND DesktopDisplayNonPeriodicEO.task_id = TaskStructurePEO.proj_element_id(+)

AND DesktopDisplayNonPeriodicEO.rbs_element_id=ProjResBrkdwnStructElePEO.rbs_element_id(+)

AND ppd.PLAN_VERSION_ID = DesktopDisplayNonPeriodicEO.PLAN_VERSION_ID

AND ppd.project_id = DesktopDisplayNonPeriodicEO.project_id

AND ProjResBrkdwnStructElePEO.RESOURCE_CLASS_ID = PjfResourceClassesVl.RESOURCE_CLASS_ID

AND PjoPlanningCurrencies.PLAN_VERSION_ID = ppd.PLAN_VERSION_ID

AND ppd.planning_option_id = PjoPlanningCurrencies.planning_option_id

AND PlanLineEO.planning_element_id = DesktopDisplayNonPeriodicEO.planning_element_id

AND PlanLineEO.txn_currency_code = DesktopDisplayNonPeriodicEO.txn_currency_code

AND DesktopDisplayNonPeriodicEO.PLAN_VERSION_ID = PjoPlanningCurrencies.PLAN_VERSION_ID

AND DesktopDisplayNonPeriodicEO.SPREAD_CURVE_ID = SpreadCurveEO.SPREAD_CURVE_ID

AND DesktopDisplayNonPeriodicEO.TXN_CURRENCY_CODE = PjoPlanningCurrencies.TXN_CURRENCY_CODE

ORDER BY TaskStructurePEO.ELEMENT_NUMBER,ProjResBrkdwnStructElePEO.ALIAS