APPS.OE_VALIDATE_LINE dependencies on OE_SHIP_TO_ORGS_V

Line 2287: From oe_ship_to_orgs_v

2283: IF nvl(lcustomer_relations,'N') = 'N' THEN
2284:
2285: Select 'VALID'
2286: Into l_dummy
2287: From oe_ship_to_orgs_v
2288: Where customer_id = p_sold_to_org_id
2289: AND site_use_id = p_ship_to_org_id
2290: AND status = 'A'
2291: AND address_status ='A'; --bug 2752321

Line 2327: FROM OE_SHIP_TO_ORGS_V SHP

2323: RETURN TRUE;
2324: ELSIF lcustomer_relations = 'A' THEN
2325: SELECT 'VALID'
2326: INTO l_dummy
2327: FROM OE_SHIP_TO_ORGS_V SHP
2328: WHERE SHP.ORGANIZATION_ID =p_ship_to_org_id
2329: AND SHP.STATUS = 'A'
2330: AND SHP.ADDRESS_STATUS ='A' --bug 2752321
2331: AND SYSDATE BETWEEN NVL(SHP.START_DATE_ACTIVE, SYSDATE)