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

Line 155: from msc_sup_dem_entries

151: -- only. they are mutually exclusive. --
152: ------------------------------------------------
153: cursor oh_cur is
154: select 'exists'
155: from msc_sup_dem_entries
156: where
157: plan_id = -1
158: and publisher_order_type = ALLOCATED_ONHAND
159: and customer_id = p_customer_id

Line 182: from msc_sup_dem_entries

178: supplier_item_name,
179: supplier_item_description,
180: new_order_placement_date rtf_start_date,
181: receipt_date rtf_end_date
182: from msc_sup_dem_entries
183: where plan_id = -1
184: and publisher_order_type = REPLENISHMENT
185: and customer_id = p_customer_id
186: and nvl(customer_site_id,-99) = nvl(p_customer_site_id,-99)

Line 197: from msc_sup_dem_entries

193:
194: -- QIP,IP in replenishment orders with release_status = 1
195: cursor qip_cur is
196: select round(nvl(quantity_in_process,0), 6) qip, round(implemented_quantity,6) ip
197: from msc_sup_dem_entries
198: where plan_id = -1
199: and publisher_order_type = REPLENISHMENT
200: and customer_id = p_customer_id
201: and customer_site_id = p_customer_site_id

Line 213: from msc_sup_dem_entries

209: -- requisition details
210: cursor requisition_cur is
211: select round(sum(primary_quantity),6) primary_quantity,
212: round(sum(tp_quantity),6) tp_quantity
213: from msc_sup_dem_entries
214: where plan_id = -1
215: and publisher_order_type in (REQUISITION, PO)
216: and customer_id = p_customer_id
217: and customer_site_id = p_customer_site_id

Line 237: from msc_sup_dem_entries

233: customer_item_name,
234: customer_item_description,
235: supplier_item_name,
236: supplier_item_description
237: from msc_sup_dem_entries
238: where plan_id = -1
239: and publisher_order_type = c_onhand_type
240: and customer_id = p_customer_id
241: and nvl(customer_site_id,-99) = nvl(p_customer_site_id,-99)

Line 262: msc_sup_dem_entries a,

258: a.customer_item_description,
259: a.supplier_item_name,
260: a.supplier_item_description
261: from
262: msc_sup_dem_entries a,
263: msc_trading_partner_maps map,
264: msc_trading_partners tp,
265: msc_assignment_sets assignmentset,
266: msc_sr_assignments assignment,

Line 306: from msc_sup_dem_entries

302: cursor intransit_cur is
303: SELECT count(*) count,
304: round(SUM(primary_quantity),6) primary_quantity,
305: round(SUM(decode(publisher_id, supplier_id, tp_quantity, primary_quantity)),6) tp_quantity
306: from msc_sup_dem_entries
307: where plan_id = -1
308: and publisher_order_type = ASN
309: and supplier_id = p_supplier_id
310: and nvl(supplier_site_id, -99) = nvl(p_supplier_site_id, -99)

Line 331: from msc_sup_dem_entries

327: customer_item_name,
328: customer_item_description,
329: supplier_item_name,
330: supplier_item_description
331: from msc_sup_dem_entries
332: where plan_id = -1
333: and publisher_order_type = ASN
334: and supplier_id = p_supplier_id
335: and nvl(supplier_site_id, -99) = nvl(p_supplier_site_id, -99)

Line 356: from msc_sup_dem_entries

352: customer_item_name,
353: customer_item_description,
354: supplier_item_name,
355: supplier_item_description
356: from msc_sup_dem_entries
357: where plan_id = -1
358: and publisher_order_type = SHIPMENT_RECEIPT
359: and customer_id = p_customer_id
360: and nvl(customer_site_id,-99) = nvl(p_customer_site_id,-99)

Line 371: from msc_sup_dem_entries

367:
368: cursor total_receipt_cur is
369: select round(sum(primary_quantity),6) primary_quantity,
370: round(sum(tp_quantity),6) tp_quantity
371: from msc_sup_dem_entries
372: where plan_id = -1
373: and publisher_order_type = SHIPMENT_RECEIPT
374: and customer_id = p_customer_id
375: and nvl(customer_site_id,-99) = nvl(p_customer_site_id,-99)

Line 876: FROM msc_sup_dem_entries msde

872: l_sum_receipt_qty OUT NOCOPY NUMBER, l_last_receipt_qty OUT NOCOPY NUMBER, l_last_receipt_date OUT NOCOPY DATE)
873: IS
874: CURSOR c1 IS
875: SELECT nvl(msde.primary_quantity, 0.0), msde.receipt_date, msde.primary_uom
876: FROM msc_sup_dem_entries msde
877: WHERE msde.customer_id = p_customer_id
878: AND customer_site_id = p_customer_site_id
879: AND msde.supplier_id = p_supplier_id
880: AND msde.inventory_item_id = p_inventory_item_id

Line 888: FROM msc_sup_dem_entries msde

884: ORDER BY msde.receipt_date DESC;
885:
886: CURSOR c2 IS
887: SELECT nvl(msde.primary_quantity, 0.0), msde.primary_uom
888: FROM msc_sup_dem_entries msde
889: WHERE customer_id = p_customer_id
890: AND customer_site_id = p_customer_site_id
891: AND supplier_id = p_supplier_id
892: AND inventory_item_id = p_inventory_item_id

Line 965: FROM msc_sup_dem_entries so

961: l_conv_found BOOLEAN;
962:
963: CURSOR c1 IS
964: SELECT nvl(so.primary_quantity, 0), primary_uom
965: FROM msc_sup_dem_entries so
966: WHERE so.publisher_order_type = SALES_ORDER
967: AND so.customer_id = p_customer_id
968: AND so.customer_site_id = p_customer_site_id
969: AND so.supplier_id = p_supplier_id

Line 978: FROM msc_sup_dem_entries req

974:
975:
976: CURSOR c2 IS
977: SELECT nvl(req.primary_quantity, 0), primary_uom
978: FROM msc_sup_dem_entries req
979: WHERE req.publisher_order_type = REQUISITION
980: AND req.customer_id = p_customer_id
981: AND req.customer_site_id = p_customer_site_id
982: AND req.supplier_id = p_supplier_id

Line 1049: FROM msc_sup_dem_entries msde

1045: l_order_qty NUMBER;
1046:
1047: CURSOR c1 IS
1048: SELECT nvl(msde.primary_quantity, 0.0), primary_uom
1049: FROM msc_sup_dem_entries msde
1050: WHERE customer_id = p_customer_id
1051: AND customer_site_id = p_customer_site_id
1052: AND supplier_id = p_supplier_id
1053: AND inventory_item_id = p_inventory_item_id

Line 1097: FROM msc_sup_dem_entries msde

1093: CURSOR c1 IS
1094: SELECT order_number,
1095: receipt_date AS next_asn_date,
1096: primary_quantity AS primary_quantity, primary_uom
1097: FROM msc_sup_dem_entries msde
1098: WHERE msde.plan_id = -1
1099: AND msde.publisher_order_type = ASN
1100: AND msde.supplier_id = p_supplier_id
1101: AND msde.inventory_item_id = p_inventory_item_id

Line 1110: FROM msc_sup_dem_entries msde

1106:
1107:
1108: CURSOR c2 IS
1109: SELECT nvl(msde.primary_quantity, 0.0), primary_uom
1110: FROM msc_sup_dem_entries msde
1111: WHERE customer_id = p_customer_id
1112: AND customer_site_id = p_customer_site_id
1113: AND supplier_id = p_supplier_id
1114: AND inventory_item_id = p_inventory_item_id

Line 1189: FROM msc_sup_dem_entries msde

1185: -- customer/-site/supplier/item.
1186:
1187: SELECT msde.primary_quantity, msde.receipt_date, msde.quantity_in_process
1188: INTO l_replenishment_quantity, l_replenishment_date, l_quantity_in_process
1189: FROM msc_sup_dem_entries msde
1190: WHERE customer_id = p_customer_id
1191: AND customer_site_id = p_customer_site_id
1192: AND supplier_id = p_supplier_id
1193: AND inventory_item_id = p_inventory_item_id

Line 1341: FROM msc_sup_dem_entries

1337: r_onhand_date OUT NOCOPY DATE)
1338: IS
1339: CURSOR c1 IS
1340: SELECT nvl(primary_quantity, 0), new_schedule_date, primary_uom
1341: FROM msc_sup_dem_entries
1342: WHERE plan_id = -1
1343: AND publisher_order_type = ALLOCATED_ONHAND
1344: AND inventory_item_id = p_inventory_item_id
1345: AND customer_id = p_customer_id

Line 1365: FROM msc_sup_dem_entries

1361: BEGIN
1362: -- Unallocated
1363: SELECT primary_quantity, new_schedule_date, primary_uom
1364: INTO l_sum_unallocated_qty, l_unallocated_date, l_primary_uom
1365: FROM msc_sup_dem_entries
1366: WHERE plan_id = -1
1367: AND publisher_order_type = UNALLOCATED_ONHAND
1368: AND inventory_item_id = p_inventory_item_id
1369: AND publisher_id = p_customer_id

Line 1783: FROM msc_sup_dem_entries

1779: l_exists VARCHAR2(20);
1780:
1781: CURSOR oh_cur is
1782: SELECT 'exists'
1783: FROM msc_sup_dem_entries
1784: WHERE plan_id = -1
1785: AND publisher_order_type = ALLOCATED_ONHAND
1786: AND customer_id = p_customer_id
1787: AND nvl(customer_site_id,-99) = nvl(p_customer_site_id,-99)

Line 1953: FROM msc_sup_dem_entries

1949: /* For a item only one of following order types will exist order_forecast,sales_forecast or historical_sales */
1950:
1951: CURSOR order_forecast_cur is
1952: SELECT sum(primary_quantity) as primary_quantity, trunc(key_date) as key_date, primary_uom
1953: FROM msc_sup_dem_entries
1954: WHERE plan_id = -1
1955: AND publisher_order_type IN (ORDER_FORECAST,SALES_FORECAST,HISTORICAL_SALES)
1956: AND inventory_item_id = p_inventory_item_id
1957: AND customer_id = p_customer_id

Line 2093: FROM msc_sup_dem_entries

2089: CURSOR safety_stock_cur is
2090: SELECT primary_quantity AS primary_quantity,
2091: trunc(key_date) AS key_date,
2092: bucket_type as bucket_type, primary_uom
2093: FROM msc_sup_dem_entries
2094: WHERE plan_id = -1
2095: AND publisher_order_type = SAFETY_STOCK
2096: AND publisher_id = p_customer_id
2097: AND publisher_site_id = p_customer_site_id

Line 2162: FROM msc_sup_dem_entries

2158: IS
2159: CURSOR requisition_cur is
2160: SELECT primary_quantity AS primary_quantity,
2161: tp_quantity AS tp_quantity, trunc(key_date) AS key_date, primary_uom
2162: FROM msc_sup_dem_entries
2163: WHERE plan_id = -1
2164: AND publisher_order_type = REQUISITION
2165: AND customer_id = p_customer_id
2166: AND customer_site_id = p_customer_site_id

Line 2517: FROM msc_sup_dem_entries supdem

2513:
2514: CURSOR c_total_supplies (l_forecast_horizon number)
2515: IS
2516: SELECT sum(primary_quantity),key_date
2517: FROM msc_sup_dem_entries supdem
2518: WHERE supdem.publisher_order_type in (20,13,15,16)
2519: AND supdem.inventory_item_id = p_inventory_item_id
2520: AND supdem.customer_id=p_customer_id
2521: AND supdem.customer_site_id=p_customer_site_id

Line 2536: FROM msc_sup_dem_entries supdem

2532:
2533: CURSOR c_total_demands(forecast_horizon IN NUMBER)
2534: IS
2535: SELECT sum(primary_quantity),key_date
2536: FROM msc_sup_dem_entries supdem
2537: WHERE publisher_order_type =2
2538: AND supdem.inventory_item_id=p_inventory_item_id
2539: AND supdem.customer_id=p_customer_id
2540: AND supdem.customer_site_id=p_customer_site_id

Line 2573: FROM msc_sup_dem_entries supdem

2569:
2570: CURSOR c_onhand
2571: IS
2572: SELECT primary_quantity
2573: FROM msc_sup_dem_entries supdem
2574: WHERE publisher_order_type =9
2575: AND supdem.inventory_item_id=p_inventory_item_id
2576: AND supdem.customer_id=p_customer_id
2577: AND supdem.customer_site_id=p_customer_site_id

Line 2981: FROM msc_sup_dem_entries supdem

2977:
2978: CURSOR c_total_demands(forecast_horizon IN NUMBER, v_index IN NUMBER)
2979: IS
2980: SELECT nvl(sum(primary_quantity),0)
2981: FROM msc_sup_dem_entries supdem
2982: WHERE publisher_order_type =2
2983: AND supdem.inventory_item_id=p_inventory_item_id
2984: AND supdem.customer_id=p_customer_id
2985: AND supdem.customer_site_id=p_customer_site_id