APPS.QP_CROSS_ORDER_VOLUME_LOAD dependencies on OE_CUST_TOTAL_AMTS_ALL

Line 581: DELETE FROM OE_CUST_TOTAL_AMTS_ALL;

577:
578: IF (g_org_id IS NULL) OR (NOT multi_org_install)
579: THEN
580:
581: DELETE FROM OE_CUST_TOTAL_AMTS_ALL;
582:
583: ELSE
584:
585:

Line 586: DELETE FROM OE_CUST_TOTAL_AMTS_ALL

582:
583: ELSE
584:
585:
586: DELETE FROM OE_CUST_TOTAL_AMTS_ALL
587: WHERE ORG_ID = g_org_id;
588:
589: END IF;
590:

Line 611: INSERT INTO OE_CUST_TOTAL_AMTS_ALL

607: THEN
608:
609: IF multi_org_install THEN
610:
611: INSERT INTO OE_CUST_TOTAL_AMTS_ALL
612: (org_id,
613: sold_to_org_id,
614: period1_total_amount,
615: period2_total_amount,

Line 675: INSERT INTO OE_CUST_TOTAL_AMTS_ALL

671: GROUP BY lines.org_id,lines.sold_to_org_id);
672:
673: ELSE
674:
675: INSERT INTO OE_CUST_TOTAL_AMTS_ALL
676: (org_id,
677: sold_to_org_id,
678: period1_total_amount,
679: period2_total_amount,