DBA Data[Home] [Help]

APPS.MRP_PO_RESCHEDULE dependencies on MRP_PO_RESCHEDULE

Line 1: PACKAGE BODY MRP_PO_RESCHEDULE AS

1: PACKAGE BODY MRP_PO_RESCHEDULE AS
2: /* $Header: MRPPOREB.pls 120.7.12010000.2 2008/10/17 12:05:22 lsindhur ship $ */
3:
4: l_debug varchar2(30) := 'Y';
5: g_dblink VARCHAR2(129);

Line 100: 'INSERT INTO mrp_po_reschedule_gt (

96: RETURN;
97: END IF;
98:
99: l_sql_stmt :=
100: 'INSERT INTO mrp_po_reschedule_gt (
101: purchase_order_id
102: , po_number
103: , line_id
104: , line_location_id

Line 290: FROM mrp_po_reschedule_gt i,

286: , g_qtys
287: , g_promise_dates
288: , g_uoms
289: , g_operating_units
290: FROM mrp_po_reschedule_gt i,
291: mtl_uom_conversions u
292: WHERE i.uom = u.uom_code
293: AND u.inventory_item_id = 0
294: ORDER BY i.purchase_order_id;

Line 819: END mrp_po_reschedule;

815: RAISE;
816:
817: END launch_reschedule_po;
818:
819: END mrp_po_reschedule;