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

Line 28: l_item_name msc_sup_dem_entries.item_name%type;

24: l_customer_site_id Number;
25: l_publisher_id Number;
26: l_publisher_site_id Number;
27: l_item_id Number;
28: l_item_name msc_sup_dem_entries.item_name%type;
29: l_item_desc msc_sup_dem_entries.item_description%type;
30: l_publisher_name msc_sup_dem_entries.publisher_name%type;
31: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
32: l_supplier_name msc_sup_dem_entries.supplier_name%type;

Line 29: l_item_desc msc_sup_dem_entries.item_description%type;

25: l_publisher_id Number;
26: l_publisher_site_id Number;
27: l_item_id Number;
28: l_item_name msc_sup_dem_entries.item_name%type;
29: l_item_desc msc_sup_dem_entries.item_description%type;
30: l_publisher_name msc_sup_dem_entries.publisher_name%type;
31: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
32: l_supplier_name msc_sup_dem_entries.supplier_name%type;
33: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;

Line 30: l_publisher_name msc_sup_dem_entries.publisher_name%type;

26: l_publisher_site_id Number;
27: l_item_id Number;
28: l_item_name msc_sup_dem_entries.item_name%type;
29: l_item_desc msc_sup_dem_entries.item_description%type;
30: l_publisher_name msc_sup_dem_entries.publisher_name%type;
31: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
32: l_supplier_name msc_sup_dem_entries.supplier_name%type;
33: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
34: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;

Line 31: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;

27: l_item_id Number;
28: l_item_name msc_sup_dem_entries.item_name%type;
29: l_item_desc msc_sup_dem_entries.item_description%type;
30: l_publisher_name msc_sup_dem_entries.publisher_name%type;
31: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
32: l_supplier_name msc_sup_dem_entries.supplier_name%type;
33: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
34: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
35: l_supplier_item_desc msc_sup_dem_entries.supplier_item_description%type;

Line 32: l_supplier_name msc_sup_dem_entries.supplier_name%type;

28: l_item_name msc_sup_dem_entries.item_name%type;
29: l_item_desc msc_sup_dem_entries.item_description%type;
30: l_publisher_name msc_sup_dem_entries.publisher_name%type;
31: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
32: l_supplier_name msc_sup_dem_entries.supplier_name%type;
33: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
34: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
35: l_supplier_item_desc msc_sup_dem_entries.supplier_item_description%type;
36: l_customer_name msc_sup_dem_entries.customer_name%type;

Line 33: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;

29: l_item_desc msc_sup_dem_entries.item_description%type;
30: l_publisher_name msc_sup_dem_entries.publisher_name%type;
31: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
32: l_supplier_name msc_sup_dem_entries.supplier_name%type;
33: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
34: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
35: l_supplier_item_desc msc_sup_dem_entries.supplier_item_description%type;
36: l_customer_name msc_sup_dem_entries.customer_name%type;
37: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;

Line 34: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;

30: l_publisher_name msc_sup_dem_entries.publisher_name%type;
31: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
32: l_supplier_name msc_sup_dem_entries.supplier_name%type;
33: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
34: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
35: l_supplier_item_desc msc_sup_dem_entries.supplier_item_description%type;
36: l_customer_name msc_sup_dem_entries.customer_name%type;
37: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
38: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;

Line 35: l_supplier_item_desc msc_sup_dem_entries.supplier_item_description%type;

31: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
32: l_supplier_name msc_sup_dem_entries.supplier_name%type;
33: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
34: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
35: l_supplier_item_desc msc_sup_dem_entries.supplier_item_description%type;
36: l_customer_name msc_sup_dem_entries.customer_name%type;
37: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
38: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
39: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;

Line 36: l_customer_name msc_sup_dem_entries.customer_name%type;

32: l_supplier_name msc_sup_dem_entries.supplier_name%type;
33: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
34: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
35: l_supplier_item_desc msc_sup_dem_entries.supplier_item_description%type;
36: l_customer_name msc_sup_dem_entries.customer_name%type;
37: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
38: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
39: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;
40: l_exception_type_name fnd_lookup_values.meaning%type;

Line 37: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;

33: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
34: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
35: l_supplier_item_desc msc_sup_dem_entries.supplier_item_description%type;
36: l_customer_name msc_sup_dem_entries.customer_name%type;
37: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
38: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
39: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;
40: l_exception_type_name fnd_lookup_values.meaning%type;
41: l_exception_group_name fnd_lookup_values.meaning%type;

Line 38: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;

34: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
35: l_supplier_item_desc msc_sup_dem_entries.supplier_item_description%type;
36: l_customer_name msc_sup_dem_entries.customer_name%type;
37: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
38: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
39: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;
40: l_exception_type_name fnd_lookup_values.meaning%type;
41: l_exception_group_name fnd_lookup_values.meaning%type;
42: l_total_supply NUMBER;

Line 39: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;

35: l_supplier_item_desc msc_sup_dem_entries.supplier_item_description%type;
36: l_customer_name msc_sup_dem_entries.customer_name%type;
37: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
38: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
39: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;
40: l_exception_type_name fnd_lookup_values.meaning%type;
41: l_exception_group_name fnd_lookup_values.meaning%type;
42: l_total_supply NUMBER;
43: l_lead_time NUMBER;

Line 93: FROM msc_sup_dem_entries_v sd,

89: itm.organization_id,
90: itm.supplier_id,
91: itm.supplier_site_id,
92: itm.sr_instance_id
93: FROM msc_sup_dem_entries_v sd,
94: msc_item_suppliers itm,
95: MSC_X_ITEM_SUPPLIERS_GTT iut,
96: MSC_X_ITEM_ORGS_GTT iot,
97: MSC_X_ITEM_SITES_GTT ist

Line 116: if there does not exist any data in msc_sup_dem_entries. */

112: )
113: )
114:
115: UNION /* Bug 3737298 : added UNION so that VMI Engine generates MATERIAL SHORTAGE Exception even
116: if there does not exist any data in msc_sup_dem_entries. */
117:
118: SELECT distinct 1 ,
119: iot.company_key ,
120: iut.object_id ,

Line 148: FROM msc_sup_dem_entries_v sd,

144: --and ( itm.supplier_site_id is not null or rownum = 1)
145: AND itm.vmi_flag = 1
146: AND NVL(itm.enable_vmi_auto_replenish_flag, 'N') = 'N'
147: AND itm.inventory_item_id NOT IN ( select distinct sd.inventory_item_id
148: FROM msc_sup_dem_entries_v sd,
149: msc_item_suppliers itm,
150: MSC_X_ITEM_SUPPLIERS_GTT iut,
151: MSC_X_ITEM_ORGS_GTT iot,
152: MSC_X_ITEM_SITES_GTT ist

Line 189: FROM msc_sup_dem_entries_v sd,

185: itm.organization_id,
186: itm.supplier_id,
187: itm.supplier_site_id,
188: itm.sr_instance_id
189: FROM msc_sup_dem_entries_v sd,
190: msc_item_suppliers itm,
191: MSC_X_ITEM_SUPPLIERS_GTT iut,
192: MSC_X_ITEM_ORGS_GTT iot,
193: MSC_X_ITEM_SITES_GTT ist

Line 230: FROM msc_sup_dem_entries sd

226: , sd.supplier_id, sd.tp_quantity
227: , sd.primary_quantity
228: )
229: )
230: FROM msc_sup_dem_entries sd
231: WHERE sd.inventory_item_id = p_inventory_item_id
232: AND sd.supplier_site_id = p_supplier_site_id
233: AND sd.supplier_id = p_supplier_id
234: AND sd.plan_id = p_plan_id

Line 253: FROM msc_sup_dem_entries sd

249: , p_supplier_site_id IN NUMBER
250: , p_time_fence_end_date IN DATE
251: ) IS
252: SELECT sd.primary_quantity
253: FROM msc_sup_dem_entries sd
254: WHERE sd.inventory_item_id = p_inventory_item_id
255: AND sd.publisher_site_id = p_customer_site_id
256: AND sd.plan_id = p_plan_id
257: AND sd.publisher_order_type = 9 -- ALLOCATED_ONHAND

Line 274: FROM msc_sup_dem_entries sd

270: , p_supplier_site_id IN NUMBER
271: , p_time_fence_end_date IN DATE
272: ) IS
273: SELECT SUM(sd.primary_quantity)
274: FROM msc_sup_dem_entries sd
275: WHERE sd.publisher_site_id = p_customer_site_id
276: AND sd.inventory_item_id = p_inventory_item_id
277: AND sd.publisher_order_type = 16 -- SHIPMENT_RECEIPT
278: AND sd.plan_id = p_plan_id

Line 295: FROM msc_sup_dem_entries sd

291: , p_supplier_site_id IN NUMBER
292: , p_time_fence_end_date IN DATE
293: ) IS
294: SELECT SUM(sd.primary_quantity)
295: FROM msc_sup_dem_entries sd
296: WHERE sd.publisher_site_id = p_customer_site_id
297: AND sd.inventory_item_id = p_inventory_item_id
298: AND sd.publisher_order_type = 20 -- REQUISITION
299: AND sd.plan_id = p_plan_id

Line 317: FROM msc_sup_dem_entries sd

313: , p_supplier_site_id IN NUMBER
314: , p_time_fence_end_date IN DATE
315: ) IS
316: SELECT SUM(sd.primary_quantity)
317: FROM msc_sup_dem_entries sd
318: WHERE sd.publisher_site_id = p_customer_site_id
319: AND sd.inventory_item_id = p_inventory_item_id
320: AND sd.publisher_order_type = 13 -- PURCHASE_ORDER
321: AND sd.plan_id = p_plan_id

Line 338: FROM msc_sup_dem_entries sd

334: , p_supplier_id IN NUMBER
335: , p_supplier_site_id IN NUMBER
336: ) IS
337: SELECT sd.primary_quantity
338: FROM msc_sup_dem_entries sd
339: WHERE sd.publisher_site_id = p_customer_site_id
340: AND sd.inventory_item_id = p_inventory_item_id
341: AND sd.publisher_order_type = 19 -- REPLENISHMENT
342: AND sd.plan_id = p_plan_id

Line 400: FROM msc_sup_dem_entries_v sd

396: sd.supplier_site_name,
397: sd.item_name,
398: sd.item_description,
399: sd.supplier_item_name
400: FROM msc_sup_dem_entries_v sd
401: WHERE sd.inventory_item_id = p_inventory_item_id
402: AND sd.plan_id = p_plan_id
403: AND sd.customer_site_id = p_organization_id
404: AND sd.supplier_id = p_supplier_id

Line 425: FROM msc_sup_dem_entries_v sd

421: sd.customer_site_name,
422: sd.item_name,
423: sd.item_description,
424: sd.customer_item_name
425: FROM msc_sup_dem_entries_v sd
426: WHERE sd.inventory_item_id = p_inventory_item_id
427: AND sd.plan_id = p_plan_id
428: AND sd.customer_site_id = p_organization_id
429: AND sd.supplier_id = p_supplier_id