APPS.OE_VALIDATE_HEADER dependencies on OE_SHIP_TO_ORGS_V

Line 1667: FROM oe_ship_to_orgs_v

1663: ('Cr: No',2);
1664:
1665: SELECT 'VALID'
1666: INTO l_dummy
1667: FROM oe_ship_to_orgs_v
1668: WHERE customer_id = p_header_rec.sold_to_org_id
1669: AND site_use_id = p_header_rec.ship_to_org_id
1670: AND status = 'A'
1671: AND address_status ='A'; --bug 2752321

Line 1703: FROM OE_SHIP_TO_ORGS_V SHP

1699: ('Cr: Yes- After the select',2);
1700: ELSIF lcustomer_relations = 'A' THEN
1701: SELECT 'VALID'
1702: INTO l_dummy
1703: FROM OE_SHIP_TO_ORGS_V SHP
1704: WHERE SHP.ORGANIZATION_ID =p_header_rec.ship_to_org_id
1705: AND SHP.STATUS = 'A'
1706: AND SHP.ADDRESS_STATUS ='A' --bug 2752321
1707: AND SYSDATE BETWEEN NVL(SHP.START_DATE_ACTIVE, SYSDATE)