APPS.OE_VALIDATE_HEADER dependencies on OE_SHIP_TO_ORGS_V

Line 1599: FROM oe_ship_to_orgs_v

1595: ('Cr: No',2);
1596:
1597: SELECT 'VALID'
1598: INTO l_dummy
1599: FROM oe_ship_to_orgs_v
1600: WHERE customer_id = p_header_rec.sold_to_org_id
1601: AND site_use_id = p_header_rec.ship_to_org_id
1602: AND status = 'A'
1603: AND address_status ='A'; --bug 2752321

Line 1635: FROM OE_SHIP_TO_ORGS_V SHP

1631: ('Cr: Yes- After the select',2);
1632: ELSIF lcustomer_relations = 'A' THEN
1633: SELECT 'VALID'
1634: INTO l_dummy
1635: FROM OE_SHIP_TO_ORGS_V SHP
1636: WHERE SHP.ORGANIZATION_ID =p_header_rec.ship_to_org_id
1637: AND SHP.STATUS = 'A'
1638: AND SHP.ADDRESS_STATUS ='A' --bug 2752321
1639: AND SYSDATE BETWEEN NVL(SHP.START_DATE_ACTIVE, SYSDATE)