APPS.MSC_X_VMI_POREQ dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 137: from po_vendor_sites_all pvsa, po_Requisitions_interface_All pri

133: l_apps_version number;
134: l_po_application VARCHAR2(2) := 'PO' ;
135:
136: Cursor c1 is select pvsa.vendor_site_id,pri.rowid
137: from po_vendor_sites_all pvsa, po_Requisitions_interface_All pri
138: where pri.suggested_vendor_id = pvsa.vendor_id
139: and pri.suggested_vendor_site = pvsa.vendor_site_code
140: and pri.org_id = pvsa.org_id
141: and pri.interface_source_code = 'MSC';

Line 146: from PO_REQUISITIONS_INTERFACE_ALL

142:
143: -- MOAC Changes
144: Cursor Purchasing_OU is
145: Select distinct org_id
146: from PO_REQUISITIONS_INTERFACE_ALL
147: WHERE batch_id = l_PO_BATCH_NUMBER;
148:
149: CURSOR c1_rec is
150: SELECT item_id,

Line 153: from PO_REQUISITIONS_INTERFACE_all

149: CURSOR c1_rec is
150: SELECT item_id,
151: destination_organization_id,
152: rowid
153: from PO_REQUISITIONS_INTERFACE_all
154: where batch_id = l_PO_BATCH_NUMBER;
155:
156: var_revision VARCHAR2(3);
157: var_revision_ctrl NUMBER;

Line 228: 'INSERT INTO PO_REQUISITIONS_INTERFACE_ALL'

224: || lv_dblink
225: || '/' || lv_instance_id
226: );
227: lv_sqlstmt:=
228: 'INSERT INTO PO_REQUISITIONS_INTERFACE_ALL'
229: ||' ( PROJECT_ACCOUNTING_CONTEXT,'
230: ||' PROJECT_ID,'
231: ||' TASK_ID,'
232: ||' NEED_BY_DATE,'

Line 302: log_message('Rows inserted into PO_REQUISITIONS_INTERFACE_all = ' || SQL%ROWCOUNT);

298:
299: EXECUTE IMMEDIATE lv_sqlstmt
300: USING lv_instance_id;
301:
302: log_message('Rows inserted into PO_REQUISITIONS_INTERFACE_all = ' || SQL%ROWCOUNT);
303:
304:
305: For i in c1
306: Loop

Line 308: update po_requisitions_interface_all

304:
305: For i in c1
306: Loop
307:
308: update po_requisitions_interface_all
309: set suggested_vendor_site_id = i.vendor_site_id
310: where rowid = i.rowid;
311:
312: End loop;

Line 315: -- Populating SECONDARY_UOM_CODE and SECONDARY_QUANTITY in PO_REQUISITIONS_INTERFACE_ALL from MTL_SYSTEM_ITEMS

311:
312: End loop;
313:
314: -- fix for 2541517
315: -- Populating SECONDARY_UOM_CODE and SECONDARY_QUANTITY in PO_REQUISITIONS_INTERFACE_ALL from MTL_SYSTEM_ITEMS
316: BEGIN
317:
318:
319: SELECT pri.rowid,

Line 326: FROM PO_REQUISITIONS_INTERFACE_ALL pri,

322: BULK COLLECT
323: INTO lv_pri_rowid,
324: lv_sec_uom_code,
325: lv_sec_uom_qty
326: FROM PO_REQUISITIONS_INTERFACE_ALL pri,
327: MTL_SYSTEM_ITEMS msi
328: WHERE pri.ITEM_ID = msi.INVENTORY_ITEM_ID
329: AND pri.DESTINATION_ORGANIZATION_ID = msi.ORGANIZATION_ID
330: AND msi.SECONDARY_UOM_CODE is not NULL

Line 343: UPDATE PO_REQUISITIONS_INTERFACE_ALL pri

339: IF lv_req_count <> 0 THEN
340:
341: FOR j IN 1..lv_req_count LOOP
342:
343: UPDATE PO_REQUISITIONS_INTERFACE_ALL pri
344: SET pri.SECONDARY_UOM_CODE = lv_sec_uom_code(j),
345: pri.SECONDARY_QUANTITY = lv_sec_uom_qty(j)
346: WHERE ROWID= lv_pri_rowid(j);
347:

Line 381: UPDATE PO_REQUISITIONS_INTERFACE_all

377: END;
378:
379: BEGIN
380:
381: UPDATE PO_REQUISITIONS_INTERFACE_all
382: set item_revision = DECODE(var_purchasing_by_rev, NULL,
383: DECODE(var_revision_ctrl, NOT_UNDER_REV_CONTROL, NULL, var_revision),
384: PURCHASING_BY_REV, var_revision,
385: NOT_PURCHASING_BY_REV, NULL)

Line 507: from po_vendor_sites_all pvsa, po_Requisitions_interface_All pri

503: lv_result BOOLEAN;
504:
505:
506: Cursor c1 is select pvsa.vendor_site_id,pri.rowid
507: from po_vendor_sites_all pvsa, po_Requisitions_interface_All pri
508: where pri.suggested_vendor_id = pvsa.vendor_id
509: and pri.suggested_vendor_site = pvsa.vendor_site_code
510: and pri.org_id = pvsa.org_id
511: and pri.interface_source_code = 'MSC';

Line 538: 'INSERT INTO PO_REQUISITIONS_INTERFACE_all'

534: from MRP_AP_APPS_INSTANCES;
535:
536:
537: lv_sqlstmt:=
538: 'INSERT INTO PO_REQUISITIONS_INTERFACE_all'
539: ||' ( PROJECT_ACCOUNTING_CONTEXT,'
540: ||' PROJECT_ID,'
541: ||' TASK_ID,'
542: ||' NEED_BY_DATE,'

Line 616: update po_requisitions_interface_all

612:
613: For i in c1
614: Loop
615:
616: update po_requisitions_interface_all
617: set suggested_vendor_site_id = i.vendor_site_id
618: where rowid = i.rowid;
619:
620: End loop;