APPS.MRP_PO_RESCHEDULE dependencies on MSC_PURCHASE_ORDER_INTERFACE

Line 140: FROM msc_purchase_order_interface' || p_dblink ||

136: , Sysdate
137: , fnd_global.user_id
138: , Sysdate
139: , fnd_global.user_id
140: FROM msc_purchase_order_interface' || p_dblink ||
141: ' WHERE sr_instance_id = :p_instance_id
142: AND batch_id = :p_batch_id)';
143:
144: execute immediate l_sql_stmt

Line 217: l_sql_stmt := 'DELETE FROM msc_purchase_order_interface'||p_dblink||

213: IS
214: l_sql_stmt VARCHAR2(1000);
215: BEGIN
216:
217: l_sql_stmt := 'DELETE FROM msc_purchase_order_interface'||p_dblink||
218: ' WHERE batch_id = :p_batch_id';
219: execute immediate l_sql_stmt using
220: IN p_batch_id;
221: END cleanup_destination;

Line 326: FROM msc_purchase_order_interface i,

322: , g_qtys
323: , g_promise_dates
324: , g_uoms
325: , g_operating_units
326: FROM msc_purchase_order_interface i,
327: msc_uom_conversions u
328: WHERE i.sr_instance_id = l_instance_id
329: AND i.uom = u.uom_code
330: AND u.inventory_item_id = 0

Line 657: ' from msc_purchase_order_interface' ||

653: sql_stmt:=
654: ' select po_header_id,'||
655: ' po_line_id,'||
656: ' po_number'||
657: ' from msc_purchase_order_interface' ||
658: ' where sr_instance_id = '||p_instance_id||
659: ' and batch_id ='||p_batch_id ||
660: ' and action = 2' ||
661: ' order by po_number ';

Line 898: The release Id is buried in the column order_number in MSC_SUPPLIES which comes back to MSC_PURCHASE_ORDER_INTERFACE bug 7144230*/

894: debug_message('Header id: ' || l_po_header_id );
895: -- Create a change object for the document with the line and
896: -- shipment changes.
897: /* We have to obtain the po_release_id in case of blanket PO
898: The release Id is buried in the column order_number in MSC_SUPPLIES which comes back to MSC_PURCHASE_ORDER_INTERFACE bug 7144230*/
899: select substr(l_po_number,
900: instr(l_po_number,'(',1,1)+1,
901: instr(l_po_number,')',1,1) - instr(l_po_number,'(',1,1) -1)
902: into l_po_release_num