VIEW: APPS.MSD_PRICE_LIST_LB_V

Source

View Text - Preformatted

SELECT mdp.demand_plan_id, org_pk.level_pk, item_pk.level_pk, to_number(null), to_number(null), sup_pk.level_pk, to_number(null), to_number(null), to_number(null), pl_name.stnd_cost, mdp.plan_start_date, mdp.plan_end_date, nvl(mis.item_price, itm.standard_cost), 1, 1, 'I' FROM msc_plans mpln, msd_demand_plans mdp, msc_system_items itm, msc_item_suppliers mis, msc_trading_partners mtp, msd_level_values_lb org_pk, msd_level_values_lb item_pk, msd_level_values_lb sup_pk, (select fnd_message.get_string('MSD', 'MSD_LB_STANDARD_COST') stnd_cost from dual) pl_name WHERE org_pk.level_id = 7 and org_pk.sr_level_pk =mtp.sr_instance_id ||':'|| mtp.sr_tp_id and org_pk.plan_id = mis.plan_id and mtp.partner_type = 3 and mtp.sr_instance_id = mis.sr_instance_id and mtp.sr_tp_id = mis.organization_id and item_pk.level_id = 1 and item_pk.sr_level_pk = mis.inventory_item_id and item_pk.plan_id = mis.plan_id and sup_pk.level_id = 12 and sup_pk.sr_level_pk = mis.supplier_id and sup_pk.plan_id = mis.plan_id and mis.INCLUDE_LIABILITY_AGREEMENT = 1 and mis.plan_id = itm.plan_id and mis.organization_id = itm.organization_id and mis.sr_instance_id = itm.sr_instance_id and mis.inventory_item_id = itm.inventory_item_id and mpln.plan_id = mdp.liab_plan_id

View Text - HTML Formatted

SELECT MDP.DEMAND_PLAN_ID
, ORG_PK.LEVEL_PK
, ITEM_PK.LEVEL_PK
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SUP_PK.LEVEL_PK
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PL_NAME.STND_COST
, MDP.PLAN_START_DATE
, MDP.PLAN_END_DATE
, NVL(MIS.ITEM_PRICE
, ITM.STANDARD_COST)
, 1
, 1
, 'I'
FROM MSC_PLANS MPLN
, MSD_DEMAND_PLANS MDP
, MSC_SYSTEM_ITEMS ITM
, MSC_ITEM_SUPPLIERS MIS
, MSC_TRADING_PARTNERS MTP
, MSD_LEVEL_VALUES_LB ORG_PK
, MSD_LEVEL_VALUES_LB ITEM_PK
, MSD_LEVEL_VALUES_LB SUP_PK
, (SELECT FND_MESSAGE.GET_STRING('MSD'
, 'MSD_LB_STANDARD_COST') STND_COST
FROM DUAL) PL_NAME
WHERE ORG_PK.LEVEL_ID = 7
AND ORG_PK.SR_LEVEL_PK =MTP.SR_INSTANCE_ID ||':'|| MTP.SR_TP_ID
AND ORG_PK.PLAN_ID = MIS.PLAN_ID
AND MTP.PARTNER_TYPE = 3
AND MTP.SR_INSTANCE_ID = MIS.SR_INSTANCE_ID
AND MTP.SR_TP_ID = MIS.ORGANIZATION_ID
AND ITEM_PK.LEVEL_ID = 1
AND ITEM_PK.SR_LEVEL_PK = MIS.INVENTORY_ITEM_ID
AND ITEM_PK.PLAN_ID = MIS.PLAN_ID
AND SUP_PK.LEVEL_ID = 12
AND SUP_PK.SR_LEVEL_PK = MIS.SUPPLIER_ID
AND SUP_PK.PLAN_ID = MIS.PLAN_ID
AND MIS.INCLUDE_LIABILITY_AGREEMENT = 1
AND MIS.PLAN_ID = ITM.PLAN_ID
AND MIS.ORGANIZATION_ID = ITM.ORGANIZATION_ID
AND MIS.SR_INSTANCE_ID = ITM.SR_INSTANCE_ID
AND MIS.INVENTORY_ITEM_ID = ITM.INVENTORY_ITEM_ID
AND MPLN.PLAN_ID = MDP.LIAB_PLAN_ID