APPS.ECEPOI dependencies on OE_SHIP_TO_ORGS_V

Line 173: FROM oe_ship_to_orgs_v

169: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_orgid);
170: If nvl(lcustomer_relations ,'N') = 'N' Then
171: SELECT site_use_id
172: INTO l_site_use_id
173: FROM oe_ship_to_orgs_v
174: WHERE customer_id = p_customer_id
175: AND address_id = p_address_id
176: AND status = 'A';
177: ELSIF lcustomer_relations = 'Y' THEN

Line 180: From oe_ship_to_orgs_v

176: AND status = 'A';
177: ELSIF lcustomer_relations = 'Y' THEN
178: SELECT site_use_id
179: INTO l_site_use_id
180: From oe_ship_to_orgs_v
181: WHERE address_id = p_address_id
182: AND status = 'A' AND
183: customer_id in (
184: Select p_customer_id from dual