DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on HZ_CUST_ACCT_SITES

Line 15673: HZ_CUST_ACCT_SITES s

15669: s.cust_account_id
15670: INTO l_address_id,
15671: l_cust_id
15672: FROM HZ_CUST_SITE_USES_ALL u,
15673: HZ_CUST_ACCT_SITES s
15674: WHERE u.cust_acct_site_id = s.cust_acct_site_id
15675: AND u.site_use_id = p_x_line_rec.ship_to_org_id
15676: AND u.site_use_code = 'SHIP_TO';
15677: oe_debug_pub.add('ship to address:' || l_address_id||' - Customer:'||to_char(l_cust_id));

Line 21097: HZ_CUST_ACCT_SITES cas,

21093: x_state,
21094: x_zip,
21095: x_country
21096: FROM HZ_CUST_SITE_USES_ALL site,
21097: HZ_CUST_ACCT_SITES cas,
21098: hz_cust_accounts cust,
21099: hz_parties party,
21100: hz_party_sites ps,
21101: hz_locations addr