DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on HZ_CUST_SITE_USES_ALL

Line 2551: FROM HZ_CUST_SITE_USES_ALL SU_BILL,

2547: RAA_BILL_LOC.POSTAL_CODE,
2548: FT_BILL.TERRITORY_SHORT_NAME),
2549: RAA_BILL_LOC.Address_Lines_Phonetic))
2550: INTO l_raa_bill_to_concat_address
2551: FROM HZ_CUST_SITE_USES_ALL SU_BILL,
2552: Hz_Cust_Acct_Sites_All RAA_BILL,
2553: HZ_PARTY_SITES RAA_BILL_PS,
2554: Hz_Locations RAA_BILL_LOC,
2555: FND_TERRITORIES_VL FT_BILL,

Line 2605: hz_cust_site_uses_all hcsua

2601: --Yao add for bug#8769687
2602: ,
2603: hz_party_sites hps,
2604: hz_cust_acct_sites_all hcasa,
2605: hz_cust_site_uses_all hcsua
2606: --Yao add end
2607: WHERE -- h.bill_to_customer_id can find by customer trx id
2608: --h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID
2609: -- AND rac_bill.party_id = RAC_BILL_PARTY.Party_Id