DBA Data[Home] [Help]

APPS.ECE_AR_TRANSACTION dependencies on HZ_PARTY_SITES

Line 553: hz_party_sites hps,

549: CURSOR remit_cur IS
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

Line 664: hz_party_sites hps,

660: Remit_To_Code_Int,
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;