APPS.OE_OE_INLINE_ADDRESS dependencies on HZ_CUST_SITE_USES_ALL

Line 2228: from hz_cust_site_uses_all

2224: -- after creation
2225: if in_addr_location is null then
2226: select location
2227: into out_ship_to_location
2228: from hz_cust_site_uses_all
2229: where site_use_id = x_site_use_id;
2230: else
2231: out_ship_to_location := in_addr_location;
2232: end if;

Line 2290: from hz_cust_site_uses_all

2286:
2287: if in_addr_location is null then
2288: select location
2289: into out_bill_to_location
2290: from hz_cust_site_uses_all
2291: where site_use_id = x_site_use_id;
2292: else
2293: out_bill_to_location := in_addr_location;
2294: end if;

Line 2352: from hz_cust_site_uses_all

2348: -- after creation
2349: if in_addr_location is null then
2350: select location
2351: into out_deliver_to_location
2352: from hz_cust_site_uses_all
2353: where site_use_id = x_site_use_id;
2354:
2355: else
2356: out_deliver_to_location := in_addr_location;

Line 2414: from hz_cust_site_uses_all

2410: -- after creation
2411: if in_addr_location is null then
2412: select location
2413: into out_sold_to_location
2414: from hz_cust_site_uses_all
2415: where site_use_id = x_site_use_id;
2416: else
2417: out_sold_to_location := in_addr_location;
2418: end if;