APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on HZ_LOCATIONS

Line 770: FROM hz_party_sites ps, hz_locations loc,

766: AND user_pf.sys_dc_profile_code = sys_pf.sys_dc_profile_code;
767:
768: CURSOR l_lang_territory_csr (p_trxnmid IN NUMBER) IS
769: SELECT loc.language, loc.country
770: FROM hz_party_sites ps, hz_locations loc,
771: iby_trxn_summaries_all txn, hz_cust_site_uses_all hz_csu,
772: hz_cust_acct_sites_all hz_cs
773: where txn.trxnmid = p_trxnmid
774: and hz_csu.cust_acct_site_id = hz_cs.cust_acct_site_id

Line 1509: l_headers_query := l_headers_query ||'hz_locations to_loc,

1505: ELSE
1506: l_headers_query := l_headers_query || 'ar_docs_receivables_v inv_header,';
1507: END IF;
1508:
1509: l_headers_query := l_headers_query ||'hz_locations to_loc,
1510: iby_trxn_summaries_all txn
1511: WHERE txn.initiator_extension_id = inv_header.order_ext_id
1512: AND(txn.trxntypeid IN(''8'', ''9'', ''100''))
1513: AND(inv_header.ship_to_address_id = to_loc.location_id(+))