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.16.12020000.3 2012/09/04 06:52:42 neelredd ship $ */
3:
4: Type CharTab is TABLE of varchar2(2);
5: Type LongCharTab is TABLE of varchar2(240);

Line 107: 'INSERT INTO mrp_po_reschedule_gt (

103: RETURN;
104: END IF;
105:
106: l_sql_stmt :=
107: 'INSERT INTO mrp_po_reschedule_gt (
108: purchase_order_id
109: , po_number
110: , line_id
111: , line_location_id

Line 299: FROM mrp_po_reschedule_gt i,

295: , g_qtys
296: , g_promise_dates
297: , g_uoms
298: , g_operating_units
299: FROM mrp_po_reschedule_gt i,
300: mtl_uom_conversions u
301: WHERE i.uom = u.uom_code
302: AND u.inventory_item_id = 0
303: AND i.action <> 2

Line 649: ' from mrp_po_reschedule_gt ' ||

645: ' select '|| --?????
646: ' purchase_order_id,'||
647: ' line_id,'||
648: ' po_number'||
649: ' from mrp_po_reschedule_gt ' ||
650: ' where action = 2 '||
651: ' order by po_number ';
652: ELSE
653: sql_stmt:=

Line 1028: END mrp_po_reschedule;

1024: RAISE;
1025:
1026: END launch_reschedule_po;
1027:
1028: END mrp_po_reschedule;