APPS.OE_OE_INLINE_ADDRESS dependencies on HZ_CUST_SITE_USES_ALL

Line 2272: from hz_cust_site_uses_all

2268: -- after creation
2269: if in_addr_location is null then
2270: select location
2271: into out_ship_to_location
2272: from hz_cust_site_uses_all
2273: where site_use_id = x_site_use_id;
2274: else
2275: out_ship_to_location := in_addr_location;
2276: end if;

Line 2334: from hz_cust_site_uses_all

2330:
2331: if in_addr_location is null then
2332: select location
2333: into out_bill_to_location
2334: from hz_cust_site_uses_all
2335: where site_use_id = x_site_use_id;
2336: else
2337: out_bill_to_location := in_addr_location;
2338: end if;

Line 2396: from hz_cust_site_uses_all

2392: -- after creation
2393: if in_addr_location is null then
2394: select location
2395: into out_deliver_to_location
2396: from hz_cust_site_uses_all
2397: where site_use_id = x_site_use_id;
2398:
2399: else
2400: out_deliver_to_location := in_addr_location;

Line 2458: from hz_cust_site_uses_all

2454: -- after creation
2455: if in_addr_location is null then
2456: select location
2457: into out_sold_to_location
2458: from hz_cust_site_uses_all
2459: where site_use_id = x_site_use_id;
2460: else
2461: out_sold_to_location := in_addr_location;
2462: end if;