DBA Data[Home] [Help]

APPS.ECE_AR_TRANSACTION dependencies on HZ_LOCATIONS

Line 554: hz_locations loc,

550: SELECT rt.address_id
551: FROM ra_customer_trx rct,
552: hz_cust_acct_sites a,
553: hz_party_sites hps,
554: hz_locations loc,
555: ra_remit_tos rt
556: WHERE rct.customer_trx_id = Get_Remit_Address.Customer_Trx_ID
557: AND rct.bill_to_address_id = a.cust_acct_site_id AND
558: a.party_site_id = hps.party_site_id AND

Line 665: hz_locations loc

661: Remit_to_customer_name, --2291130
662: Remit_to_edi_location_code
663: FROM hz_cust_acct_sites hcas,
664: hz_party_sites hps,
665: hz_locations loc
666: WHERE hps.party_site_id = hcas.party_site_id
667: AND hps.location_id = loc.location_id
668: AND hcas.cust_acct_site_id = l_Remit_To_Address_ID;
669: -- bug 4718847