APPS.OE_VALIDATE_HEADER dependencies on OE_DELIVER_TO_ORGS_V

Line 1763: FROM oe_deliver_to_orgs_v

1759: oe_debug_pub.add('Cr: No',2);
1760:
1761: SELECT 'VALID'
1762: INTO l_dummy
1763: FROM oe_deliver_to_orgs_v
1764: WHERE customer_id = p_header_rec.sold_to_org_id
1765: AND site_use_id = p_header_rec.deliver_to_org_id
1766: AND status = 'A'
1767: AND address_status ='A'; --bug 2752321

Line 1800: FROM OE_DELIVER_TO_ORGS_V DEL

1796: ELSIF lcustomer_relations = 'A' THEN
1797:
1798: SELECT 'VALID'
1799: INTO l_dummy
1800: FROM OE_DELIVER_TO_ORGS_V DEL
1801: WHERE DEL.ORGANIZATION_ID =p_header_rec.deliver_to_org_id
1802: AND DEL.STATUS = 'A'
1803: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
1804: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)