APPS.OE_BLANKET_UTIL dependencies on OE_SHIP_TO_ORGS_V

Line 132: From oe_ship_to_orgs_v

128: IF g_customer_relations = 'N' THEN
129:
130: Select 'VALID'
131: Into l_dummy
132: From oe_ship_to_orgs_v
133: Where customer_id = p_sold_to_org_id
134: AND site_use_id = p_ship_to_org_id
135: AND status = 'A'
136: AND address_status ='A'; --bug 2752321

Line 170: FROM OE_SHIP_TO_ORGS_V SHP

166: RETURN TRUE;
167: ELSIF g_customer_relations = 'A' THEN
168: SELECT 'VALID'
169: INTO l_dummy
170: FROM OE_SHIP_TO_ORGS_V SHP
171: WHERE SHP.ORGANIZATION_ID =p_ship_to_org_id
172: AND SHP.STATUS = 'A'
173: AND SHP.ADDRESS_STATUS ='A' --bug 2752321
174: AND SYSDATE BETWEEN NVL(SHP.START_DATE_ACTIVE, SYSDATE)

Line 9524: FROM oe_ship_to_orgs_v

9520: if mc1x.ship_to_org_id is not null then
9521: --Ship to
9522: BEGIN
9523: SELECT 'VALID' INTO l_dummy
9524: FROM oe_ship_to_orgs_v
9525: WHERE customer_id = p_sold_to_org_id
9526: AND site_use_id = mc1x.ship_to_org_id
9527: AND status = 'A'
9528: and address_status='A';