APPS.OE_VALIDATE_LINE dependencies on OE_SHIP_TO_ORGS_V

Line 2412: From oe_ship_to_orgs_v

2408: IF nvl(lcustomer_relations,'N') = 'N' THEN
2409:
2410: Select 'VALID'
2411: Into l_dummy
2412: From oe_ship_to_orgs_v
2413: Where customer_id = p_sold_to_org_id
2414: AND site_use_id = p_ship_to_org_id
2415: AND status = 'A'
2416: AND address_status ='A'; --bug 2752321

Line 2452: FROM OE_SHIP_TO_ORGS_V SHP

2448: RETURN TRUE;
2449: ELSIF lcustomer_relations = 'A' THEN
2450: SELECT 'VALID'
2451: INTO l_dummy
2452: FROM OE_SHIP_TO_ORGS_V SHP
2453: WHERE SHP.ORGANIZATION_ID =p_ship_to_org_id
2454: AND SHP.STATUS = 'A'
2455: AND SHP.ADDRESS_STATUS ='A' --bug 2752321
2456: AND SYSDATE BETWEEN NVL(SHP.START_DATE_ACTIVE, SYSDATE)