VIEW: APPS.MSD_MFG_FCST_CS_V

Source

View Text - Preformatted

SELECT mbd.FORECAST_DESIGNATOR, prd_level_id, item_pk.level_pk prd_level_value, decode( ship_to_loc_pk.sr_level_pk, -777, decode(customer_pk.sr_level_pk, -777, 11, 15), 11) geo_level_id, decode( ship_to_loc_pk.sr_level_pk, -777, decode(customer_pk.sr_level_pk, -777, ship_to_loc_pk.level_pk, customer_pk.level_pk), ship_to_loc_pk.level_pk) geo_level_value_pk, 7 org_level_id, org_pk.level_pk org_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, mbd.BUCKET_TYPE time_level_id, mbd.FORECAST_DATE, mbd.original_quantity, mbd.CURRENT_QUANTITY, mbd.creation_date, mbd.created_by, mbd.last_update_date, mbd.last_updated_by, mbd.last_update_login, mbd.last_refresh_num, mbd.created_by_refresh_num, mbd.action_code, to_number(null), to_number(null), dcs_pk.level_id dcs_level_id, dcs_pk.level_pk dcs_level_value_pk from msd_mfg_forecast mbd, msd_level_values org_pk, msd_level_values dcs_pk, msd_level_values item_pk, msd_level_values sales_channel_pk, msd_level_values ship_to_loc_pk, msd_level_values customer_pk WHERE (org_pk.instance = mbd.instance and org_pk.sr_level_pk = mbd.sr_inv_org_pk and org_pk.level_id = 7) AND (dcs_pk.instance (+) = mbd.instance and dcs_pk.sr_level_pk (+) = mbd.sr_demand_class_pk and dcs_pk.level_id (+)= 34) AND (item_pk.instance = mbd.instance and item_pk.sr_level_pk = mbd.sr_item_pk and item_pk.level_id = nvl(mbd.prd_level_id,1) ) AND (sales_channel_pk.instance = mbd.instance and sales_channel_pk.sr_level_pk = mbd.sr_sales_channel_pk and sales_channel_pk.level_id = 27) AND (ship_to_loc_pk.instance = mbd.instance and ship_to_loc_pk.sr_level_pk = mbd.sr_ship_to_loc_pk and ship_to_loc_pk.level_id = 11) AND (customer_pk.instance = mbd.instance and customer_pk.sr_level_pk = mbd.SR_CUSTOMER_PK and customer_pk.level_id = 15)

View Text - HTML Formatted

SELECT MBD.FORECAST_DESIGNATOR
, PRD_LEVEL_ID
, ITEM_PK.LEVEL_PK PRD_LEVEL_VALUE
, DECODE( SHIP_TO_LOC_PK.SR_LEVEL_PK
, -777
, DECODE(CUSTOMER_PK.SR_LEVEL_PK
, -777
, 11
, 15)
, 11) GEO_LEVEL_ID
, DECODE( SHIP_TO_LOC_PK.SR_LEVEL_PK
, -777
, DECODE(CUSTOMER_PK.SR_LEVEL_PK
, -777
, SHIP_TO_LOC_PK.LEVEL_PK
, CUSTOMER_PK.LEVEL_PK)
, SHIP_TO_LOC_PK.LEVEL_PK) GEO_LEVEL_VALUE_PK
, 7 ORG_LEVEL_ID
, ORG_PK.LEVEL_PK ORG_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
, MBD.BUCKET_TYPE TIME_LEVEL_ID
, MBD.FORECAST_DATE
, MBD.ORIGINAL_QUANTITY
, MBD.CURRENT_QUANTITY
, MBD.CREATION_DATE
, MBD.CREATED_BY
, MBD.LAST_UPDATE_DATE
, MBD.LAST_UPDATED_BY
, MBD.LAST_UPDATE_LOGIN
, MBD.LAST_REFRESH_NUM
, MBD.CREATED_BY_REFRESH_NUM
, MBD.ACTION_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DCS_PK.LEVEL_ID DCS_LEVEL_ID
, DCS_PK.LEVEL_PK DCS_LEVEL_VALUE_PK
FROM MSD_MFG_FORECAST MBD
, MSD_LEVEL_VALUES ORG_PK
, MSD_LEVEL_VALUES DCS_PK
, MSD_LEVEL_VALUES ITEM_PK
, MSD_LEVEL_VALUES SALES_CHANNEL_PK
, MSD_LEVEL_VALUES SHIP_TO_LOC_PK
, MSD_LEVEL_VALUES CUSTOMER_PK
WHERE (ORG_PK.INSTANCE = MBD.INSTANCE
AND ORG_PK.SR_LEVEL_PK = MBD.SR_INV_ORG_PK
AND ORG_PK.LEVEL_ID = 7)
AND (DCS_PK.INSTANCE (+) = MBD.INSTANCE
AND DCS_PK.SR_LEVEL_PK (+) = MBD.SR_DEMAND_CLASS_PK
AND DCS_PK.LEVEL_ID (+)= 34)
AND (ITEM_PK.INSTANCE = MBD.INSTANCE
AND ITEM_PK.SR_LEVEL_PK = MBD.SR_ITEM_PK
AND ITEM_PK.LEVEL_ID = NVL(MBD.PRD_LEVEL_ID
, 1) )
AND (SALES_CHANNEL_PK.INSTANCE = MBD.INSTANCE
AND SALES_CHANNEL_PK.SR_LEVEL_PK = MBD.SR_SALES_CHANNEL_PK
AND SALES_CHANNEL_PK.LEVEL_ID = 27)
AND (SHIP_TO_LOC_PK.INSTANCE = MBD.INSTANCE
AND SHIP_TO_LOC_PK.SR_LEVEL_PK = MBD.SR_SHIP_TO_LOC_PK
AND SHIP_TO_LOC_PK.LEVEL_ID = 11)
AND (CUSTOMER_PK.INSTANCE = MBD.INSTANCE
AND CUSTOMER_PK.SR_LEVEL_PK = MBD.SR_CUSTOMER_PK
AND CUSTOMER_PK.LEVEL_ID = 15)