eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_GTA_TRX_UTIL dependencies on HZ_CUST_ACCT_SITES

Line 219: HZ_CUST_ACCT_SITES_ALL HCASA

215: FROM ra_customer_trx_all h,
216: hz_cust_site_uses_all hcsua,
217: zx_party_tax_profile ZPTP,
218: hz_code_assignments HCA,
219: HZ_CUST_ACCT_SITES_ALL HCASA
220: WHERE h.bill_to_site_use_id=hcsua.SITE_USE_ID
221: AND hcsua.cust_acct_site_id=HCASA.CUST_ACCT_SITE_ID
222: AND HCASA.PARTY_SITE_ID=ZPTP.PARTY_ID
223: AND ZPTP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'

Line 2207: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

2203: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2204: ----Yao Zhang add end for bug#8404856
2205:
2206: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2207: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2208: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2209: l_error_string VARCHAR2(500);
2210:
2211: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;

Line 2213: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

2209: l_error_string VARCHAR2(500);
2210:
2211: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2212: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2213: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2214: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2215: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2216: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2217: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;

Line 2561: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

2557: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2558: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2559: --Yao Zhang add end for bug#8404856
2560: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2561: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2562: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2563: l_error_string VARCHAR2(500);
2564:
2565: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;

Line 2567: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

2563: l_error_string VARCHAR2(500);
2564:
2565: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2566: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2567: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2568: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2569: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2570: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2571: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;

Line 2581: l_ori_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

2577: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2578:
2579: l_ori_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2580: l_ori_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2581: l_ori_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2582: l_ori_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2583:
2584: BEGIN
2585: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 3531: l_party_site_id hz_cust_acct_sites_all.party_site_id%TYPE;

3527: l_reg_tax zx_registrations.tax%TYPE;
3528: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;
3529:
3530: l_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
3531: l_party_site_id hz_cust_acct_sites_all.party_site_id%TYPE;
3532: l_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
3533:
3534: l_tax_registration_count NUMBER;
3535: l_tax_profile_status NUMBER;

Line 3617: hz_cust_acct_sites_all

3613: party_site_id
3614: INTO
3615: l_party_site_id
3616: FROM
3617: hz_cust_acct_sites_all
3618: WHERE cust_acct_site_id = l_cust_acct_site_id;
3619: EXCEPTION
3620: WHEN no_data_found THEN
3621: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 3809: FROM HZ_CUST_ACCOUNTS acct, hz_cust_acct_sites_all acct_site

3805: THEN
3806: BEGIN
3807: SELECT party_id
3808: INTO l_party_id
3809: FROM HZ_CUST_ACCOUNTS acct, hz_cust_acct_sites_all acct_site
3810: WHERE acct.CUST_ACCount_ID = acct_site.CUST_ACCount_ID
3811: AND acct_site.party_site_id = l_party_site_id;
3812:
3813: SELECT reg.registration_number,