APPS.OE_BULK_PROCESS_HEADER dependencies on OE_DELIVER_TO_ORGS_V

Line 1537: FROM oe_deliver_to_orgs_v

1533: l_dummy VARCHAR2(10);
1534: --bug 4729536
1535: Cursor cur_customer_relations is
1536: SELECT /*MOAC_SQL_NO_CHANGE */ 'VALID'
1537: FROM oe_deliver_to_orgs_v
1538: WHERE site_use_id = p_deliver_to
1539: AND status = 'A'
1540: AND customer_id = p_sold_to
1541: AND ROWNUM = 1

Line 1546: FROM oe_deliver_to_orgs_v odto

1542:
1543: UNION ALL
1544:
1545: SELECT /*MOAC_SQL_NO_CHANGE*/ 'VALID'
1546: FROM oe_deliver_to_orgs_v odto
1547: WHERE site_use_id = p_deliver_to
1548: AND status = 'A'
1549: AND exists
1550: (

Line 1566: FROM oe_deliver_to_orgs_v

1562: IF (OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N') THEN
1563:
1564: SELECT 'VALID'
1565: INTO l_dummy
1566: FROM oe_deliver_to_orgs_v
1567: WHERE customer_id = p_sold_to
1568: AND site_use_id = p_deliver_to
1569: AND status = 'A';
1570:

Line 1575: FROM oe_deliver_to_orgs_v

1571: ELSE
1572:
1573: /*SELECT /*MOAC_SQL_NO_CHANGE 'VALID'
1574: INTO l_dummy
1575: FROM oe_deliver_to_orgs_v
1576: WHERE site_use_id = p_deliver_to
1577: AND status = 'A'
1578: AND customer_id IN (
1579: Select p_sold_to from dual