VIEW: APPS.MSD_DEM_SCN_ENTRIES_V

Source

View Text - Preformatted

SELECT m1.scenario_id, m1.sr_instance_id, nvl(m1.sr_organization_id, -23453) organization_id, nvl(mtil.tp_id, -23453) customer_id, nvl(mtsil.tp_site_id, -23453) customer_site_id, nvl(m1.sr_zone_id, -23453) zone_id, m1.inventory_item_id, nvl(m1.demand_class, '-23453') demand_class, m1.start_time start_date, m1.end_time end_date, m1.bucket_type, m1.quantity consensus_fcst, m1.priority, m1.unit_price price, mtp.currency_code FROM msd_dp_ascp_scn_entries_v m1, msc_trading_partners mtp, msc_trading_partners mtp1, msc_tp_id_lid mtil, msc_trading_partner_sites mtps, msc_tp_site_id_lid mtsil WHERE m1.demand_plan_id = 5555555 AND m1.sr_instance_id = mtp.sr_instance_id(+) AND m1.sr_organization_id = mtp.sr_tp_id(+) AND mtp.partner_type(+) = 3 and m1.sr_instance_id = mtil.sr_instance_id (+) AND m1.sr_customer_id = mtil.sr_tp_id(+) AND mtil.tp_id = mtp1.partner_id(+) AND mtil.partner_type(+) = 2 AND m1.sr_instance_id = mtsil.sr_instance_id(+) AND m1.sr_ship_to_loc_id = mtsil.sr_tp_site_id(+) AND mtsil.tp_site_id = mtps.partner_site_id(+) AND mtsil.partner_type(+) = 2

View Text - HTML Formatted

SELECT M1.SCENARIO_ID
, M1.SR_INSTANCE_ID
, NVL(M1.SR_ORGANIZATION_ID
, -23453) ORGANIZATION_ID
, NVL(MTIL.TP_ID
, -23453) CUSTOMER_ID
, NVL(MTSIL.TP_SITE_ID
, -23453) CUSTOMER_SITE_ID
, NVL(M1.SR_ZONE_ID
, -23453) ZONE_ID
, M1.INVENTORY_ITEM_ID
, NVL(M1.DEMAND_CLASS
, '-23453') DEMAND_CLASS
, M1.START_TIME START_DATE
, M1.END_TIME END_DATE
, M1.BUCKET_TYPE
, M1.QUANTITY CONSENSUS_FCST
, M1.PRIORITY
, M1.UNIT_PRICE PRICE
, MTP.CURRENCY_CODE
FROM MSD_DP_ASCP_SCN_ENTRIES_V M1
, MSC_TRADING_PARTNERS MTP
, MSC_TRADING_PARTNERS MTP1
, MSC_TP_ID_LID MTIL
, MSC_TRADING_PARTNER_SITES MTPS
, MSC_TP_SITE_ID_LID MTSIL
WHERE M1.DEMAND_PLAN_ID = 5555555
AND M1.SR_INSTANCE_ID = MTP.SR_INSTANCE_ID(+)
AND M1.SR_ORGANIZATION_ID = MTP.SR_TP_ID(+)
AND MTP.PARTNER_TYPE(+) = 3
AND M1.SR_INSTANCE_ID = MTIL.SR_INSTANCE_ID (+)
AND M1.SR_CUSTOMER_ID = MTIL.SR_TP_ID(+)
AND MTIL.TP_ID = MTP1.PARTNER_ID(+)
AND MTIL.PARTNER_TYPE(+) = 2
AND M1.SR_INSTANCE_ID = MTSIL.SR_INSTANCE_ID(+)
AND M1.SR_SHIP_TO_LOC_ID = MTSIL.SR_TP_SITE_ID(+)
AND MTSIL.TP_SITE_ID = MTPS.PARTNER_SITE_ID(+)
AND MTSIL.PARTNER_TYPE(+) = 2