APPS.QP_CROSS_ORDER_VOLUME_LOAD dependencies on OE_ITEM_CUST_VOLS_ALL

Line 350: DELETE FROM OE_ITEM_CUST_VOLS_ALL;

346:
347: IF (g_org_id IS NULL) OR (NOT l_multi_org_install)
348: THEN
349:
350: DELETE FROM OE_ITEM_CUST_VOLS_ALL;
351:
352: ELSE
353:
354: DELETE FROM OE_ITEM_CUST_VOLS_ALL

Line 354: DELETE FROM OE_ITEM_CUST_VOLS_ALL

350: DELETE FROM OE_ITEM_CUST_VOLS_ALL;
351:
352: ELSE
353:
354: DELETE FROM OE_ITEM_CUST_VOLS_ALL
355: WHERE ORG_ID = g_org_id;
356:
357: END IF;
358:

Line 367: INSERT INTO OE_ITEM_CUST_VOLS_ALL

363: LOOP
364:
365: IF l_multi_org_install THEN
366:
367: INSERT INTO OE_ITEM_CUST_VOLS_ALL
368: (org_id,
369: inventory_item_id,
370: sold_to_org_id,
371: primary_uom_code,

Line 448: INSERT INTO OE_ITEM_CUST_VOLS_ALL

444: GROUP BY lines.inventory_item_id,lines.org_id,0,lines.sold_to_org_id);
445:
446: ELSE /* not multiple sets of books */
447:
448: INSERT INTO OE_ITEM_CUST_VOLS_ALL
449: (org_id,
450: inventory_item_id,
451: sold_to_org_id,
452: primary_uom_code,