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.MSC_X_NETTING1_PKG dependencies on MSC_SUP_DEM_ENTRIES

Line 63: FROM msc_sup_dem_entries sd1,

59: sd2.supplier_site_id,
60: sd2.supplier_site_name,
61: sd2.creation_date,
62: sd2.last_refresh_number
63: FROM msc_sup_dem_entries sd1,
64: msc_sup_dem_entries sd2
65: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
66: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
67: AND sd2.plan_id = sd1.plan_id

Line 64: msc_sup_dem_entries sd2

60: sd2.supplier_site_name,
61: sd2.creation_date,
62: sd2.last_refresh_number
63: FROM msc_sup_dem_entries sd1,
64: msc_sup_dem_entries sd2
65: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
66: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
67: AND sd2.plan_id = sd1.plan_id
68: AND sd2.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER

Line 125: FROM msc_sup_dem_entries sd1,

121: sd2.customer_site_id,
122: sd2.customer_site_name,
123: sd2.creation_date,
124: sd2.last_refresh_number
125: FROM msc_sup_dem_entries sd1,
126: msc_sup_dem_entries sd2
127: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
128: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
129: AND sd2.plan_id = sd1.plan_id

Line 126: msc_sup_dem_entries sd2

122: sd2.customer_site_name,
123: sd2.creation_date,
124: sd2.last_refresh_number
125: FROM msc_sup_dem_entries sd1,
126: msc_sup_dem_entries sd2
127: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
128: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
129: AND sd2.plan_id = sd1.plan_id
130: AND sd2.publisher_order_type = msc_x_netting_pkg.SALES_ORDER

Line 192: FROM msc_sup_dem_entries sd1

188: sd1.supplier_site_id,
189: null,
190: null,
191: sd1.key_date)
192: FROM msc_sup_dem_entries sd1
193: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
194: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER -- PO
195: AND trunc(sysdate) > trunc(sd1.key_date);
196:

Line 248: FROM msc_sup_dem_entries sd1,

244: sd2.supplier_site_id,
245: sd2.supplier_site_name,
246: sd2.creation_date,
247: sd2.last_refresh_number
248: FROM msc_sup_dem_entries sd1,
249: msc_sup_dem_entries sd2
250: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
251: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
252: AND sd2.plan_id = sd1.plan_id

Line 249: msc_sup_dem_entries sd2

245: sd2.supplier_site_name,
246: sd2.creation_date,
247: sd2.last_refresh_number
248: FROM msc_sup_dem_entries sd1,
249: msc_sup_dem_entries sd2
250: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
251: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
252: AND sd2.plan_id = sd1.plan_id
253: AND sd2.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER

Line 310: FROM msc_sup_dem_entries sd1,

306: sd2.customer_site_id,
307: sd2.customer_site_name,
308: sd2.creation_date ,
309: sd2.last_refresh_number
310: FROM msc_sup_dem_entries sd1,
311: msc_sup_dem_entries sd2
312: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
313: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
314: AND sd2.plan_id = sd1.plan_id

Line 311: msc_sup_dem_entries sd2

307: sd2.customer_site_name,
308: sd2.creation_date ,
309: sd2.last_refresh_number
310: FROM msc_sup_dem_entries sd1,
311: msc_sup_dem_entries sd2
312: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
313: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
314: AND sd2.plan_id = sd1.plan_id
315: AND sd2.publisher_order_type = msc_x_netting_pkg.SALES_ORDER

Line 361: FROM msc_sup_dem_entries sd

357: sd.inventory_item_id,
358: sd.item_name,
359: sd.item_description,
360: sd.supplier_item_name
361: FROM msc_sup_dem_entries sd
362: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
363: AND sd.publisher_order_type = msc_x_netting_pkg.SALES_FORECAST
364: AND sd.supplier_id = sd.publisher_id
365: AND sd.supplier_site_id = sd.publisher_site_id

Line 388: FROM msc_sup_dem_entries sd

384: sd.inventory_item_id,
385: sd.item_name,
386: sd.item_description,
387: sd.customer_item_name
388: FROM msc_sup_dem_entries sd
389: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
390: AND sd.publisher_order_type = msc_x_netting_pkg.SALES_FORECAST
391: AND sd.customer_id = sd.publisher_id
392: AND sd.customer_site_id = sd.publisher_site_id

Line 3001: -- Check if the sales forecast data does not exist in msc_sup_dem_entries

2997: FOR j in 1..b_customer_id.COUNT
2998: LOOP
2999:
3000: ---------------------------------------------------------------------------
3001: -- Check if the sales forecast data does not exist in msc_sup_dem_entries
3002: -- at all and should not going through the bucketing loop
3003: --------------------------------------------------------------------------
3004: BEGIN
3005: select nvl(sum(sd.quantity),-999999)

Line 3007: from msc_sup_dem_entries sd

3003: --------------------------------------------------------------------------
3004: BEGIN
3005: select nvl(sum(sd.quantity),-999999)
3006: into l_sum
3007: from msc_sup_dem_entries sd
3008: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
3009: and sd.publisher_id = b_publisher_id(j)
3010: and sd.publisher_site_id = b_publisher_site_id(j)
3011: and sd.customer_id = b_customer_id(j)

Line 3153: from msc_sup_dem_entries sd

3149: select nvl(sum(sd.tp_quantity),0), --supplier centric (look at the tp qty)
3150: nvl(sum(sd.primary_quantity),0),
3151: nvl(sum(sd.quantity),0)
3152: into l_tp_total_forecast, l_total_forecast, l_posting_total_forecast
3153: from msc_sup_dem_entries sd
3154: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
3155: and sd.publisher_id = b_customer_id(j)
3156: and sd.publisher_site_id = b_customer_site_id(j)
3157: and sd.inventory_item_id = b_item_id(j)

Line 3176: from msc_sup_dem_entries sd

3172: select nvl(sum(sd.primary_quantity),0),
3173: nvl(sum(sd.tp_quantity),0),
3174: nvl(sum(sd.quantity),0)
3175: into l_total_sales_fsct, l_tp_total_sales_fsct, l_posting_total_sales_fsct
3176: from msc_sup_dem_entries sd
3177: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
3178: and sd.publisher_id = b_publisher_id(j)
3179: and sd.publisher_site_id = b_publisher_site_id(j)
3180: and sd.customer_id = b_customer_id(j)

Line 3771: -- Check if the sales forecast data does not exist in msc_sup_dem_entries

3767: FOR j in 1..b_item_id.COUNT
3768: LOOP
3769:
3770: ---------------------------------------------------------------------------
3771: -- Check if the sales forecast data does not exist in msc_sup_dem_entries
3772: -- at all and should not going through the bucketing loop
3773: --------------------------------------------------------------------------
3774: BEGIN
3775: select nvl(sum(sd.quantity),-999999)

Line 3777: from msc_sup_dem_entries sd

3773: --------------------------------------------------------------------------
3774: BEGIN
3775: select nvl(sum(sd.quantity),-999999)
3776: into l_sum
3777: from msc_sup_dem_entries sd
3778: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
3779: and sd.publisher_id = b_publisher_id(j)
3780: and sd.publisher_site_id = b_publisher_site_id(j)
3781: and sd.supplier_id = b_supplier_id(j)

Line 3926: from msc_sup_dem_entries sd

3922: select nvl(sum(sd.primary_quantity),0),
3923: nvl(sum(sd.tp_quantity),0) ,
3924: nvl(sum(sd.quantity),0)
3925: into l_total_forecast, l_tp_total_forecast, l_posting_total_forecast
3926: from msc_sup_dem_entries sd
3927: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
3928: and sd.publisher_id = b_publisher_id(j)
3929: and sd.publisher_site_id = b_publisher_site_id(j)
3930: and sd.supplier_id = b_supplier_id(j)

Line 3949: from msc_sup_dem_entries sd

3945: select nvl(sum(sd.tp_quantity),0),
3946: nvl(sum(sd.primary_quantity),0),
3947: nvl(sum(sd.quantity),0)
3948: into l_tp_total_sales_fsct, l_total_sales_fsct, l_posting_total_sales_fsct
3949: from msc_sup_dem_entries sd
3950: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
3951: and sd.publisher_id = b_supplier_id(j)
3952: and sd.publisher_site_id = b_supplier_site_id(j)
3953: and sd.customer_id = b_publisher_id(j)