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_NETTING4_PKG dependencies on MSC_SUP_DEM_ENTRIES

Line 39: FROM msc_sup_dem_entries sd

35: sd.supplier_site_name,
36: sd.supplier_item_name,
37: sd.supplier_item_description,
38: sd.last_update_date
39: FROM msc_sup_dem_entries sd
40: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
41: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
42: AND sd.quantity = 0
43: AND nvl(sd.last_refresh_number,-1) > nvl(p_refresh_number,-1)

Line 55: from msc_sup_dem_entries

51: AND nvl(sdh.line_number, -99) = nvl(sd.line_number, -99)
52: AND nvl(sdh.release_number,-99) = nvl(sd.release_number, -99)
53: AND sdh.quantity_new =
54: (select sum(quantity)
55: from msc_sup_dem_entries
56: where publisher_order_type = 15
57: and end_order_number = sd.order_number
58: and nvl(end_order_line_number,-99) = nvl(sd.line_number, -99)
59: and nvl(end_order_rel_number, -99) = nvl(sd.release_number, -99)));

Line 92: FROM msc_sup_dem_entries sd1,

88: sd1.line_number,
89: sd1.key_date,
90: sd2.key_date_new,
91: sd2.key_date_old
92: FROM msc_sup_dem_entries sd1,
93: msc_sup_dem_history sd2
94: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
95: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
96: AND sd2.plan_id = sd1.plan_id

Line 139: FROM msc_sup_dem_entries sd1,

135: sd1.line_number,
136: sd1.key_date,
137: sd2.key_date_new,
138: sd2.key_date_old
139: FROM msc_sup_dem_entries sd1,
140: msc_sup_dem_history sd2
141: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
142: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
143: AND sd2.plan_id = sd1.plan_id

Line 189: FROM msc_sup_dem_entries sd

185: sd.supplier_item_name,
186: sd.supplier_item_description,
187: sd.creation_date,
188: sd.last_update_date
189: FROM msc_sup_dem_entries sd
190: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
191: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
192: AND sd.acceptance_required_flag = 'R'
193: AND nvl(sd.last_refresh_number,-1) > nvl(p_refresh_number,-1);

Line 221: FROM msc_sup_dem_entries sd

217: sd.supplier_site_id,
218: sd.supplier_site_name,
219: sd.supplier_item_name,
220: sd.supplier_item_description
221: FROM msc_sup_dem_entries sd
222: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
223: AND sd.publisher_order_type = msc_x_netting_pkg.SALES_FORECAST
224: AND sd.customer_id = sd.publisher_id
225: AND sd.customer_site_id = sd.publisher_site_id

Line 251: FROM msc_sup_dem_entries sd

247: sd.supplier_site_id,
248: sd.supplier_site_name,
249: sd.supplier_item_name,
250: sd.supplier_item_description
251: FROM msc_sup_dem_entries sd
252: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
253: AND sd.publisher_order_type = msc_x_netting_pkg.ORDER_FORECAST
254: AND trunc(sd.key_date) between
255: add_months(trunc(sysdate), -3) and trunc(sysdate);

Line 279: FROM msc_sup_dem_entries sd

275: sd.supplier_site_id,
276: sd.supplier_site_name,
277: sd.supplier_item_name,
278: sd.supplier_item_description
279: FROM msc_sup_dem_entries sd
280: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
281: AND sd.publisher_order_type = msc_x_netting_pkg.HISTORICAL_SALES
282: AND trunc(sd.key_date) between
283: add_months(trunc(sysdate), -3) and trunc(sysdate);

Line 311: FROM msc_sup_dem_entries sd

307: sd.supplier_site_id,
308: sd.supplier_site_name,
309: sd.supplier_item_name,
310: sd.supplier_item_description
311: FROM msc_sup_dem_entries sd
312: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
313: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
314: AND trunc(sd.key_date) between
315: add_months(trunc(sysdate), -3) and trunc(sysdate);

Line 325: FROM msc_sup_dem_entries sd1,

321: p_item_id in Number,
322: p_order_number in Varchar2) Is
323: SELECT sd1.primary_quantity, sd1.tp_quantity,sd1.quantity,
324: sd2.primary_quantity, sd2.tp_quantity,sd2.quantity
325: FROM msc_sup_dem_entries sd1,
326: msc_sup_dem_entries sd2
327: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
328: AND sd1.publisher_id = p_company_id
329: AND sd1.publisher_site_id = p_org_id

Line 326: msc_sup_dem_entries sd2

322: p_order_number in Varchar2) Is
323: SELECT sd1.primary_quantity, sd1.tp_quantity,sd1.quantity,
324: sd2.primary_quantity, sd2.tp_quantity,sd2.quantity
325: FROM msc_sup_dem_entries sd1,
326: msc_sup_dem_entries sd2
327: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
328: AND sd1.publisher_id = p_company_id
329: AND sd1.publisher_site_id = p_org_id
330: AND sd1.inventory_item_id = p_item_id

Line 368: FROM msc_sup_dem_entries sd

364: sd.publisher_site_id,
365: sd.inventory_item_id,
366: sd.supplier_id,
367: sd.supplier_site_id
368: FROM msc_sup_dem_entries sd
369: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
370: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
371: AND trunc(sd.key_date) between
372: add_months(trunc(sysdate), -3) and trunc(sysdate);

Line 425: FROM msc_sup_dem_entries sd

421: sd.supplier_site_id,
422: sd.supplier_site_name,
423: sd.supplier_item_name,
424: sd.supplier_item_description
425: FROM msc_sup_dem_entries sd
426: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
427: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
428: AND sd.publisher_id = p_publisher_id
429: AND sd.publisher_site_id = p_publisher_site_id

Line 454: FROM msc_sup_dem_entries sd1,

450: Note: in release 11.5.10, a shipping control context will be honored
451: for all relevant transactions in CP. The impact will be on PO/SO/ASN/shipment receipt
452: Therefore, the key_date will be used instead on receipt or ship date for exception
453: ---------------------------------------------------------------------------------*/
454: FROM msc_sup_dem_entries sd1,
455: msc_sup_dem_entries sd2,
456: msc_sup_dem_entries sd3
457: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
458: AND sd1.publisher_id = p_supplier_id

Line 455: msc_sup_dem_entries sd2,

451: for all relevant transactions in CP. The impact will be on PO/SO/ASN/shipment receipt
452: Therefore, the key_date will be used instead on receipt or ship date for exception
453: ---------------------------------------------------------------------------------*/
454: FROM msc_sup_dem_entries sd1,
455: msc_sup_dem_entries sd2,
456: msc_sup_dem_entries sd3
457: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
458: AND sd1.publisher_id = p_supplier_id
459: AND sd1.publisher_site_id = p_supplier_site_id

Line 456: msc_sup_dem_entries sd3

452: Therefore, the key_date will be used instead on receipt or ship date for exception
453: ---------------------------------------------------------------------------------*/
454: FROM msc_sup_dem_entries sd1,
455: msc_sup_dem_entries sd2,
456: msc_sup_dem_entries sd3
457: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
458: AND sd1.publisher_id = p_supplier_id
459: AND sd1.publisher_site_id = p_supplier_site_id
460: AND sd1.inventory_item_id = p_item_id

Line 496: FROM msc_sup_dem_entries sd1,

492: Note: in release 11.5.10, a shipping control context will be honored
493: for all relevant transactions in CP. The impact will be on PO/SO/ASN/shipment receipt
494: Therefore, the key_date will be used instead on receipt or ship date for exception
495: ---------------------------------------------------------------------------------*/
496: FROM msc_sup_dem_entries sd1,
497: msc_sup_dem_entries sd2
498: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
499: AND sd1.publisher_id = p_supplier_id
500: AND sd1.publisher_site_id = p_supplier_site_id

Line 497: msc_sup_dem_entries sd2

493: for all relevant transactions in CP. The impact will be on PO/SO/ASN/shipment receipt
494: Therefore, the key_date will be used instead on receipt or ship date for exception
495: ---------------------------------------------------------------------------------*/
496: FROM msc_sup_dem_entries sd1,
497: msc_sup_dem_entries sd2
498: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
499: AND sd1.publisher_id = p_supplier_id
500: AND sd1.publisher_site_id = p_supplier_site_id
501: AND sd1.inventory_item_id = p_item_id

Line 537: FROM msc_sup_dem_entries sd1

533: for all relevant transactions in CP. The impact will be on PO/SO/ASN/shipment receipt
534: Therefore, the key_date will be used instead on receipt or ship date for exception
535: ---------------------------------------------------------------------------------*/
536:
537: FROM msc_sup_dem_entries sd1
538: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
539: AND sd1.publisher_id = p_publisher_id
540: AND sd1.publisher_site_id = p_publisher_site_id
541: AND sd1.inventory_item_id = p_item_id

Line 572: FROM msc_sup_dem_entries sd

568: sd.supplier_site_id,
569: sd.supplier_site_name,
570: sd.supplier_item_name,
571: sd.supplier_item_description
572: FROM msc_sup_dem_entries sd
573: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
574: AND sd.publisher_order_type = msc_x_netting_pkg.HISTORICAL_SALES
575: AND trunc(sd.key_date) between
576: add_months(trunc(sysdate), -3)and trunc(sysdate);

Line 604: msc_sup_dem_entries sd2,

600: sd1.supplier_site_name,
601: sd1.supplier_item_name,
602: sd1.supplier_item_description
603: FROM msc_sup_dem_history sd1,
604: msc_sup_dem_entries sd2,
605: msc_item_suppliers itm,
606: msc_trading_partners part,
607: msc_trading_partner_maps map
608: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID

Line 708: from msc_sup_dem_entries sd,

704: sd.publisher_site_id,
705: sd.inventory_item_id,
706: sd.supplier_id,
707: sd.supplier_site_id
708: from msc_sup_dem_entries sd,
709: msc_x_exception_details dt
710: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
711: and sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
712: AND nvl(sd.last_refresh_number,-1) > nvl(p_refresh_number,-1)

Line 748: from msc_sup_dem_entries sd,

744: sd.publisher_site_id,
745: sd.inventory_item_id,
746: sd.supplier_id,
747: sd.supplier_site_id
748: from msc_sup_dem_entries sd,
749: msc_x_exception_details dt
750: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
751: and sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
752: AND nvl(sd.last_refresh_number,-1) > nvl(p_refresh_number,-1)

Line 1860: from msc_sup_dem_entries sd

1856: nvl(sum(sd.quantity),0)
1857: into l_total_historical_sales,
1858: l_tp_total_historical_sales,
1859: l_p_total_historical_sales
1860: from msc_sup_dem_entries sd
1861: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
1862: and sd.publisher_id = b_publisher_id(j)
1863: and sd.publisher_site_id = b_publisher_site_id(j)
1864: and sd.inventory_item_id = b_item_id(j)

Line 1877: from msc_sup_dem_entries sd

1873: select nvl(sum(sd.primary_quantity),0),
1874: nvl(sum(sd.tp_quantity),0),
1875: nvl(sum(sd.quantity),0)
1876: into l_total_forecast, l_tp_total_forecast, l_posting_total_forecast
1877: from msc_sup_dem_entries sd
1878: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
1879: and sd.publisher_id = b_publisher_id(j)
1880: and sd.publisher_site_id = b_publisher_site_id(j)
1881: and sd.inventory_item_id = b_item_id(j)

Line 2410: from msc_sup_dem_entries sd

2406: select nvl(sum(sd.primary_quantity),0),
2407: nvl(sum(sd.tp_quantity),0),
2408: nvl(sum(sd.quantity),0)
2409: into l_historical_sales, l_tp_historical_sales, l_posting_historical_sales
2410: from msc_sup_dem_entries sd
2411: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
2412: and sd.publisher_id = b_publisher_id(j)
2413: and sd.publisher_site_id = b_publisher_site_id(j)
2414: and sd.inventory_item_id = b_item_id(j)

Line 2426: from msc_sup_dem_entries sd

2422:
2423: select nvl(sum(sd.primary_quantity),0), nvl(sum(sd.tp_quantity),0),
2424: nvl(sum(sd.quantity),0)
2425: into l_forecast, l_tp_forecast, l_posting_forecast
2426: from msc_sup_dem_entries sd
2427: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
2428: and sd.publisher_id = b_publisher_id(j)
2429: and sd.publisher_site_id = b_publisher_site_id(j)
2430: and sd.inventory_item_id = b_item_id(j)

Line 3087: from msc_sup_dem_entries sd

3083: nvl(sum(sd.quantity),0)
3084: into l_total_historical_sales,
3085: l_tp_total_historical_sales,
3086: l_p_total_historical_sales
3087: from msc_sup_dem_entries sd
3088: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
3089: and sd.publisher_id = b_publisher_id(j)
3090: and sd.publisher_site_id = b_publisher_site_id(j)
3091: and sd.inventory_item_id = b_item_id(j)

Line 3104: from msc_sup_dem_entries sd

3100: select nvl(sum(sd.primary_quantity),0),
3101: nvl(sum(sd.tp_quantity),0),
3102: nvl(sum(sd.quantity),0)
3103: into l_total_onhand, l_tp_total_onhand, l_posting_total_onhand
3104: from msc_sup_dem_entries sd
3105: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
3106: and sd.publisher_id = b_publisher_id(j)
3107: and sd.publisher_site_id = b_publisher_site_id(j)
3108: and sd.inventory_item_id = b_item_id(j)