eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_COMPOSITE_GROUPING dependencies on MSD_LEVEL_VALUES

Line 398: msd_level_values org_pk,

394: null,
395: dcs_pk.level_value
396: from
397: msd_mfg_forecast mbd,
398: msd_level_values org_pk,
399: msd_level_values dcs_pk,
400: msd_level_values item_pk,
401: msd_level_values sales_channel_pk,
402: msd_level_values ship_to_loc_pk

Line 399: msd_level_values dcs_pk,

395: dcs_pk.level_value
396: from
397: msd_mfg_forecast mbd,
398: msd_level_values org_pk,
399: msd_level_values dcs_pk,
400: msd_level_values item_pk,
401: msd_level_values sales_channel_pk,
402: msd_level_values ship_to_loc_pk
403: WHERE (org_pk.instance = mbd.instance and org_pk.sr_level_pk = mbd.sr_inv_org_pk and org_pk.level_id = 7)

Line 400: msd_level_values item_pk,

396: from
397: msd_mfg_forecast mbd,
398: msd_level_values org_pk,
399: msd_level_values dcs_pk,
400: msd_level_values item_pk,
401: msd_level_values sales_channel_pk,
402: msd_level_values ship_to_loc_pk
403: WHERE (org_pk.instance = mbd.instance and org_pk.sr_level_pk = mbd.sr_inv_org_pk and org_pk.level_id = 7)
404: AND (dcs_pk.instance = mbd.instance and dcs_pk.sr_level_pk = mbd.sr_demand_class_pk and dcs_pk.level_id = 34)

Line 401: msd_level_values sales_channel_pk,

397: msd_mfg_forecast mbd,
398: msd_level_values org_pk,
399: msd_level_values dcs_pk,
400: msd_level_values item_pk,
401: msd_level_values sales_channel_pk,
402: msd_level_values ship_to_loc_pk
403: WHERE (org_pk.instance = mbd.instance and org_pk.sr_level_pk = mbd.sr_inv_org_pk and org_pk.level_id = 7)
404: AND (dcs_pk.instance = mbd.instance and dcs_pk.sr_level_pk = mbd.sr_demand_class_pk and dcs_pk.level_id = 34)
405: AND (item_pk.instance = mbd.instance and item_pk.sr_level_pk = mbd.sr_item_pk and item_pk.level_id = 1)

Line 402: msd_level_values ship_to_loc_pk

398: msd_level_values org_pk,
399: msd_level_values dcs_pk,
400: msd_level_values item_pk,
401: msd_level_values sales_channel_pk,
402: msd_level_values ship_to_loc_pk
403: WHERE (org_pk.instance = mbd.instance and org_pk.sr_level_pk = mbd.sr_inv_org_pk and org_pk.level_id = 7)
404: AND (dcs_pk.instance = mbd.instance and dcs_pk.sr_level_pk = mbd.sr_demand_class_pk and dcs_pk.level_id = 34)
405: AND (item_pk.instance = mbd.instance and item_pk.sr_level_pk = mbd.sr_item_pk and item_pk.level_id = 1)
406: 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)