APPS.OE_VALIDATE_LINE dependencies on OE_DELIVER_TO_ORGS_V

Line 2494: FROM oe_deliver_to_orgs_v

2490:
2491: IF nvl(lcustomer_relations,'N') = 'N' THEN
2492: SELECT 'VALID'
2493: INTO l_dummy
2494: FROM oe_deliver_to_orgs_v
2495: WHERE customer_id = p_sold_to_org_id
2496: AND site_use_id = p_deliver_to_org_id
2497: AND status = 'A'
2498: AND address_status ='A';--bug 2752321

Line 2539: FROM OE_DELIVER_TO_ORGS_V DEL

2535: ELSIF lcustomer_relations = 'A' THEN
2536:
2537: SELECT 'VALID'
2538: INTO l_dummy
2539: FROM OE_DELIVER_TO_ORGS_V DEL
2540: WHERE DEL.ORGANIZATION_ID =p_deliver_to_org_id
2541: AND DEL.STATUS = 'A'
2542: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
2543: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)