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 ZX_REGISTRATIONS

Line 3183: l_tp_registration_number zx_registrations.registration_number%TYPE;

3179: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
3180: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
3181: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
3182: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
3183: l_tp_registration_number zx_registrations.registration_number%TYPE;
3184: l_fp_reg_number_count NUMBER;
3185: l_amount zx_lines.taxable_amt%TYPE;
3186: l_currency_code VARCHAR2(30);
3187: l_error_string VARCHAR2(500);

Line 3525: l_tax_registration_number zx_registrations.registration_number%TYPE;

3521: l_tax zx_lines.tax%TYPE;
3522: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
3523: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
3524: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3525: l_tax_registration_number zx_registrations.registration_number%TYPE;
3526: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;
3527: l_reg_tax zx_registrations.tax%TYPE;
3528: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;
3529:

Line 3526: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;

3522: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
3523: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
3524: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3525: l_tax_registration_number zx_registrations.registration_number%TYPE;
3526: l_reg_tax_regime_code zx_registrations.tax_regime_code%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;

Line 3527: l_reg_tax zx_registrations.tax%TYPE;

3523: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
3524: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3525: l_tax_registration_number zx_registrations.registration_number%TYPE;
3526: l_reg_tax_regime_code zx_registrations.tax_regime_code%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;

Line 3528: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;

3524: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3525: l_tax_registration_number zx_registrations.registration_number%TYPE;
3526: l_reg_tax_regime_code zx_registrations.tax_regime_code%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;

Line 3537: l_tp_registration_number zx_registrations.registration_number%TYPE;

3533:
3534: l_tax_registration_count NUMBER;
3535: l_tax_profile_status NUMBER;
3536:
3537: l_tp_registration_number zx_registrations.registration_number%TYPE;
3538: l_tp_registration_number_a zx_registrations.registration_number%TYPE;
3539: l_tp_registration_number_b zx_registrations.registration_number%TYPE;
3540: l_tp_registration_number_c zx_registrations.registration_number%TYPE;
3541:

Line 3538: l_tp_registration_number_a zx_registrations.registration_number%TYPE;

3534: l_tax_registration_count NUMBER;
3535: l_tax_profile_status NUMBER;
3536:
3537: l_tp_registration_number zx_registrations.registration_number%TYPE;
3538: l_tp_registration_number_a zx_registrations.registration_number%TYPE;
3539: l_tp_registration_number_b zx_registrations.registration_number%TYPE;
3540: l_tp_registration_number_c zx_registrations.registration_number%TYPE;
3541:
3542: l_return_status VARCHAR2(200);

Line 3539: l_tp_registration_number_b zx_registrations.registration_number%TYPE;

3535: l_tax_profile_status NUMBER;
3536:
3537: l_tp_registration_number zx_registrations.registration_number%TYPE;
3538: l_tp_registration_number_a zx_registrations.registration_number%TYPE;
3539: l_tp_registration_number_b zx_registrations.registration_number%TYPE;
3540: l_tp_registration_number_c zx_registrations.registration_number%TYPE;
3541:
3542: l_return_status VARCHAR2(200);
3543: l_msg_count NUMBER;

Line 3540: l_tp_registration_number_c zx_registrations.registration_number%TYPE;

3536:
3537: l_tp_registration_number zx_registrations.registration_number%TYPE;
3538: l_tp_registration_number_a zx_registrations.registration_number%TYPE;
3539: l_tp_registration_number_b zx_registrations.registration_number%TYPE;
3540: l_tp_registration_number_c zx_registrations.registration_number%TYPE;
3541:
3542: l_return_status VARCHAR2(200);
3543: l_msg_count NUMBER;
3544: l_msg_data VARCHAR2(2000);

Line 3567: zx_registrations reg

3563: ,l_reg_tax_regime_code
3564: ,l_reg_tax
3565: ,l_reg_tax_jursidiction_code
3566: FROM
3567: zx_registrations reg
3568: WHERE reg.party_tax_profile_id =p_party_tax_profile_id
3569: AND (reg.tax is NULL or reg.tax = p_tax)
3570: AND reg.tax_regime_code = p_tax_regime_code -- tax_regime_code is not null
3571: AND (reg.tax_jurisdiction_code is NULL or reg.tax_jurisdiction_code = p_tax_jurisdiction_code)

Line 3821: FROM zx_registrations reg, zx_party_tax_profile tax_prof

3817: INTO l_tax_registration_number,
3818: l_reg_tax_regime_code,
3819: l_reg_tax,
3820: l_reg_tax_jursidiction_code
3821: FROM zx_registrations reg, zx_party_tax_profile tax_prof
3822: WHERE reg.party_tax_profile_id = tax_prof.party_tax_profile_id
3823: AND (reg.tax IS NULL OR reg.tax = l_tax)
3824: AND reg.tax_regime_code = l_tax_regime_code -- tax_regime_code is not null
3825: AND (reg.tax_jurisdiction_code IS NULL OR

Line 3949: l_tp_tax_registration_number zx_registrations.registration_number%TYPE;

3945: l_tax_type_code zx_lines.tax_type_code%TYPE;
3946: l_tax_rate NUMBER;
3947: l_gt_currency_code fnd_currencies.currency_code%TYPE;
3948: l_tax_line_id zx_lines.tax_line_id%TYPE;
3949: l_tp_tax_registration_number zx_registrations.registration_number%TYPE;
3950: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
3951:
3952:
3953: CURSOR c_tax_type_code