VIEW: APPS.MSD_MFG_FCST_V

Source

View Text - Preformatted

SELECT mbd.FORECAST_DESIGNATOR, org_pk.level_value , org_pk.level_pk, item_pk.level_value , item_pk.level_pk , customer_pk.level_value , customer_pk.level_pk, sales_channel_pk.level_value, sales_channel_pk.level_pk, ship_to_loc_pk.level_value , ship_to_loc_pk.level_pk, mbd.USER_DEFINED1, null user_defined1_pk, mbd.USER_DEFINED2, null USER_DEFINED2_PK, mbd.BUCKET_TYPE, mbd.FORECAST_DATE, mbd.RATE_END_DATE, mbd.original_quantity, mbd.CURRENT_QUANTITY from msd_mfg_forecast mbd, msd_level_values org_pk, msd_level_values item_pk, msd_level_values customer_pk, msd_level_values sales_channel_pk, msd_level_values ship_to_loc_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 (item_pk.instance = mbd.instance and item_pk.sr_level_pk = mbd.sr_item_pk and item_pk.level_id = 1) AND (customer_pk.instance(+) = mbd.instance and customer_pk.sr_level_pk(+) = mbd.sr_customer_pk and customer_pk.level_id(+) = 15) 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)

View Text - HTML Formatted

SELECT MBD.FORECAST_DESIGNATOR
, ORG_PK.LEVEL_VALUE
, ORG_PK.LEVEL_PK
, ITEM_PK.LEVEL_VALUE
, ITEM_PK.LEVEL_PK
, CUSTOMER_PK.LEVEL_VALUE
, CUSTOMER_PK.LEVEL_PK
, SALES_CHANNEL_PK.LEVEL_VALUE
, SALES_CHANNEL_PK.LEVEL_PK
, SHIP_TO_LOC_PK.LEVEL_VALUE
, SHIP_TO_LOC_PK.LEVEL_PK
, MBD.USER_DEFINED1
, NULL USER_DEFINED1_PK
, MBD.USER_DEFINED2
, NULL USER_DEFINED2_PK
, MBD.BUCKET_TYPE
, MBD.FORECAST_DATE
, MBD.RATE_END_DATE
, MBD.ORIGINAL_QUANTITY
, MBD.CURRENT_QUANTITY
FROM MSD_MFG_FORECAST MBD
, MSD_LEVEL_VALUES ORG_PK
, MSD_LEVEL_VALUES ITEM_PK
, MSD_LEVEL_VALUES CUSTOMER_PK
, MSD_LEVEL_VALUES SALES_CHANNEL_PK
, MSD_LEVEL_VALUES SHIP_TO_LOC_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 (ITEM_PK.INSTANCE = MBD.INSTANCE
AND ITEM_PK.SR_LEVEL_PK = MBD.SR_ITEM_PK
AND ITEM_PK.LEVEL_ID = 1)
AND (CUSTOMER_PK.INSTANCE(+) = MBD.INSTANCE
AND CUSTOMER_PK.SR_LEVEL_PK(+) = MBD.SR_CUSTOMER_PK
AND CUSTOMER_PK.LEVEL_ID(+) = 15)
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)