VIEW: APPS.MSD_SHIPMENT_DATA_CS_V

Source

View Text - Preformatted

SELECT 1 prd_level_id, item_pk.level_pk prd_level_value, 11 geo_level_id, ship_to_loc_pk.level_pk geo_level_value_pk, 7 org_level_id, org_pk.level_pk org_level_value_pk, 18 rep_level_id, sales_rep_pk.level_pk rep_level_value_pk, 27 chn_level_id, sales_channel_pk.level_pk chn_level_value_pk, null ud1_level_id, null ud1_level_value_pk, null ud2_level_id, null ud2_level_value_pk, decode(parent_item_pk.level_pk, null, null, 1) prd_parent_level_id, parent_item_pk.level_pk prd_parent_level_value_pk, 9 time_level_id, msd.BOOKED_DATE , msd.REQUESTED_DATE, msd.PROMISED_DATE, msd.SHIPPED_DATE, MSD.AMOUNT, MSD.QTY_SHIPPED, msd.creation_date, msd.created_by, msd.last_update_date, msd.last_updated_by, msd.last_update_login, msd.last_refresh_num, msd.created_by_refresh_num, msd.action_code, msd.scheduled_ship_date, msd.scheduled_arrival_date, dcs_pk.level_id dcs_level_id, dcs_pk.level_pk from msd_shipment_data msd, msd_level_values org_pk, msd_level_values dcs_pk, msd_level_values item_pk, msd_level_values sales_channel_pk, msd_level_values sales_rep_pk, msd_level_values ship_to_loc_pk, msd_level_values parent_item_pk WHERE (org_pk.instance = msd.instance and org_pk.sr_level_pk = msd.sr_inv_org_pk and org_pk.level_id = 7) AND (dcs_pk.instance (+)= msd.instance and dcs_pk.sr_level_pk (+)= msd.sr_demand_class_pk and dcs_pk.level_id (+) = 34) AND (item_pk.instance = msd.instance and item_pk.sr_level_pk = msd.sr_item_pk and item_pk.level_id = 1) AND (sales_channel_pk.instance = msd.instance and sales_channel_pk.sr_level_pk = msd.sr_sales_channel_pk and sales_channel_pk.level_id = 27) AND (sales_rep_pk.instance = msd.instance and sales_rep_pk.sr_level_pk = msd.sr_sales_rep_pk and sales_rep_pk.level_id = 18) AND (ship_to_loc_pk.instance = msd.instance and ship_to_loc_pk.sr_level_pk = msd.sr_ship_to_loc_pk and ship_to_loc_pk.level_id = 11) AND (parent_item_pk.instance(+) = msd.instance and parent_item_pk.sr_level_pk(+) = msd.sr_parent_item_pk and parent_item_pk.level_id(+) = 1 ) AND nvl(msd.order_source_id, 0) <> 10

View Text - HTML Formatted

SELECT 1 PRD_LEVEL_ID
, ITEM_PK.LEVEL_PK PRD_LEVEL_VALUE
, 11 GEO_LEVEL_ID
, SHIP_TO_LOC_PK.LEVEL_PK GEO_LEVEL_VALUE_PK
, 7 ORG_LEVEL_ID
, ORG_PK.LEVEL_PK ORG_LEVEL_VALUE_PK
, 18 REP_LEVEL_ID
, SALES_REP_PK.LEVEL_PK REP_LEVEL_VALUE_PK
, 27 CHN_LEVEL_ID
, SALES_CHANNEL_PK.LEVEL_PK CHN_LEVEL_VALUE_PK
, NULL UD1_LEVEL_ID
, NULL UD1_LEVEL_VALUE_PK
, NULL UD2_LEVEL_ID
, NULL UD2_LEVEL_VALUE_PK
, DECODE(PARENT_ITEM_PK.LEVEL_PK
, NULL
, NULL
, 1) PRD_PARENT_LEVEL_ID
, PARENT_ITEM_PK.LEVEL_PK PRD_PARENT_LEVEL_VALUE_PK
, 9 TIME_LEVEL_ID
, MSD.BOOKED_DATE
, MSD.REQUESTED_DATE
, MSD.PROMISED_DATE
, MSD.SHIPPED_DATE
, MSD.AMOUNT
, MSD.QTY_SHIPPED
, MSD.CREATION_DATE
, MSD.CREATED_BY
, MSD.LAST_UPDATE_DATE
, MSD.LAST_UPDATED_BY
, MSD.LAST_UPDATE_LOGIN
, MSD.LAST_REFRESH_NUM
, MSD.CREATED_BY_REFRESH_NUM
, MSD.ACTION_CODE
, MSD.SCHEDULED_SHIP_DATE
, MSD.SCHEDULED_ARRIVAL_DATE
, DCS_PK.LEVEL_ID DCS_LEVEL_ID
, DCS_PK.LEVEL_PK
FROM MSD_SHIPMENT_DATA MSD
, MSD_LEVEL_VALUES ORG_PK
, MSD_LEVEL_VALUES DCS_PK
, MSD_LEVEL_VALUES ITEM_PK
, MSD_LEVEL_VALUES SALES_CHANNEL_PK
, MSD_LEVEL_VALUES SALES_REP_PK
, MSD_LEVEL_VALUES SHIP_TO_LOC_PK
, MSD_LEVEL_VALUES PARENT_ITEM_PK
WHERE (ORG_PK.INSTANCE = MSD.INSTANCE
AND ORG_PK.SR_LEVEL_PK = MSD.SR_INV_ORG_PK
AND ORG_PK.LEVEL_ID = 7)
AND (DCS_PK.INSTANCE (+)= MSD.INSTANCE
AND DCS_PK.SR_LEVEL_PK (+)= MSD.SR_DEMAND_CLASS_PK
AND DCS_PK.LEVEL_ID (+) = 34)
AND (ITEM_PK.INSTANCE = MSD.INSTANCE
AND ITEM_PK.SR_LEVEL_PK = MSD.SR_ITEM_PK
AND ITEM_PK.LEVEL_ID = 1)
AND (SALES_CHANNEL_PK.INSTANCE = MSD.INSTANCE
AND SALES_CHANNEL_PK.SR_LEVEL_PK = MSD.SR_SALES_CHANNEL_PK
AND SALES_CHANNEL_PK.LEVEL_ID = 27)
AND (SALES_REP_PK.INSTANCE = MSD.INSTANCE
AND SALES_REP_PK.SR_LEVEL_PK = MSD.SR_SALES_REP_PK
AND SALES_REP_PK.LEVEL_ID = 18)
AND (SHIP_TO_LOC_PK.INSTANCE = MSD.INSTANCE
AND SHIP_TO_LOC_PK.SR_LEVEL_PK = MSD.SR_SHIP_TO_LOC_PK
AND SHIP_TO_LOC_PK.LEVEL_ID = 11)
AND (PARENT_ITEM_PK.INSTANCE(+) = MSD.INSTANCE
AND PARENT_ITEM_PK.SR_LEVEL_PK(+) = MSD.SR_PARENT_ITEM_PK
AND PARENT_ITEM_PK.LEVEL_ID(+) = 1 )
AND NVL(MSD.ORDER_SOURCE_ID
, 0) <> 10