APPS.OE_VALIDATE_LINE dependencies on OE_DELIVER_TO_ORGS_V

Line 2369: FROM oe_deliver_to_orgs_v

2365:
2366: IF nvl(lcustomer_relations,'N') = 'N' THEN
2367: SELECT 'VALID'
2368: INTO l_dummy
2369: FROM oe_deliver_to_orgs_v
2370: WHERE customer_id = p_sold_to_org_id
2371: AND site_use_id = p_deliver_to_org_id
2372: AND status = 'A'
2373: AND address_status ='A';--bug 2752321

Line 2414: FROM OE_DELIVER_TO_ORGS_V DEL

2410: ELSIF lcustomer_relations = 'A' THEN
2411:
2412: SELECT 'VALID'
2413: INTO l_dummy
2414: FROM OE_DELIVER_TO_ORGS_V DEL
2415: WHERE DEL.ORGANIZATION_ID =p_deliver_to_org_id
2416: AND DEL.STATUS = 'A'
2417: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
2418: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)