APPS.OE_BULK_PROCESS_HEADER dependencies on OE_DELIVER_TO_ORGS_V

Line 1543: FROM oe_deliver_to_orgs_v

1539: l_dummy VARCHAR2(10);
1540: --bug 4729536
1541: Cursor cur_customer_relations is
1542: SELECT /*MOAC_SQL_NO_CHANGE */ 'VALID'
1543: FROM oe_deliver_to_orgs_v
1544: WHERE site_use_id = p_deliver_to
1545: AND status = 'A'
1546: AND customer_id = p_sold_to
1547: AND ROWNUM = 1

Line 1552: FROM oe_deliver_to_orgs_v odto

1548:
1549: UNION ALL
1550:
1551: SELECT /*MOAC_SQL_NO_CHANGE*/ 'VALID'
1552: FROM oe_deliver_to_orgs_v odto
1553: WHERE site_use_id = p_deliver_to
1554: AND status = 'A'
1555: AND exists
1556: (

Line 1572: FROM oe_deliver_to_orgs_v

1568: IF (OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N') THEN
1569:
1570: SELECT 'VALID'
1571: INTO l_dummy
1572: FROM oe_deliver_to_orgs_v
1573: WHERE customer_id = p_sold_to
1574: AND site_use_id = p_deliver_to
1575: AND status = 'A';
1576:

Line 1581: FROM oe_deliver_to_orgs_v

1577: ELSE
1578:
1579: /*SELECT /*MOAC_SQL_NO_CHANGE 'VALID'
1580: INTO l_dummy
1581: FROM oe_deliver_to_orgs_v
1582: WHERE site_use_id = p_deliver_to
1583: AND status = 'A'
1584: AND customer_id IN (
1585: Select p_sold_to from dual