APPS.OE_BLANKET_UTIL dependencies on OE_SHIP_TO_ORGS_V

Line 43: From oe_ship_to_orgs_v

39: IF g_customer_relations = 'N' THEN
40:
41: Select 'VALID'
42: Into l_dummy
43: From oe_ship_to_orgs_v
44: Where customer_id = p_sold_to_org_id
45: AND site_use_id = p_ship_to_org_id
46: AND status = 'A'
47: AND address_status ='A'; --bug 2752321

Line 81: FROM OE_SHIP_TO_ORGS_V SHP

77: RETURN TRUE;
78: ELSIF g_customer_relations = 'A' THEN
79: SELECT 'VALID'
80: INTO l_dummy
81: FROM OE_SHIP_TO_ORGS_V SHP
82: WHERE SHP.ORGANIZATION_ID =p_ship_to_org_id
83: AND SHP.STATUS = 'A'
84: AND SHP.ADDRESS_STATUS ='A' --bug 2752321
85: AND SYSDATE BETWEEN NVL(SHP.START_DATE_ACTIVE, SYSDATE)

Line 9327: FROM oe_ship_to_orgs_v

9323: if mc1x.ship_to_org_id is not null then
9324: --Ship to
9325: BEGIN
9326: SELECT 'VALID' INTO l_dummy
9327: FROM oe_ship_to_orgs_v
9328: WHERE customer_id = p_sold_to_org_id
9329: AND site_use_id = mc1x.ship_to_org_id
9330: AND status = 'A'
9331: and address_status='A';