APPS.AR_GTA_ARTRX_PROC dependencies on HZ_CUST_ACCT_SITES

Line 2122: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

2118: l_amount ra_customer_trx_lines_all.taxable_amount%TYPE;
2119:
2120: -- for get bank info by customer id
2121: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2122: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2123:
2124: l_cm_export_iv VARCHAR2(500);
2125: l_cm_export_nr VARCHAR2(500);
2126: l_index NUMBER; -- index of the nested table

Line 2552: Hz_Cust_Acct_Sites_All RAA_BILL,

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,
2556: ra_customer_trx_all h

Line 2604: hz_cust_acct_sites_all hcasa,

2600: ra_customer_trx_all h
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