APPS.OE_VALIDATE_HEADER dependencies on OE_DELIVER_TO_ORGS_V

Line 1695: FROM oe_deliver_to_orgs_v

1691: oe_debug_pub.add('Cr: No',2);
1692:
1693: SELECT 'VALID'
1694: INTO l_dummy
1695: FROM oe_deliver_to_orgs_v
1696: WHERE customer_id = p_header_rec.sold_to_org_id
1697: AND site_use_id = p_header_rec.deliver_to_org_id
1698: AND status = 'A'
1699: AND address_status ='A'; --bug 2752321

Line 1732: FROM OE_DELIVER_TO_ORGS_V DEL

1728: ELSIF lcustomer_relations = 'A' THEN
1729:
1730: SELECT 'VALID'
1731: INTO l_dummy
1732: FROM OE_DELIVER_TO_ORGS_V DEL
1733: WHERE DEL.ORGANIZATION_ID =p_header_rec.deliver_to_org_id
1734: AND DEL.STATUS = 'A'
1735: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
1736: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)