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_PARTY_TAX_PROFILE

Line 217: zx_party_tax_profile ZPTP,

213: SELECT HCA.CLASS_CODE
214: INTO l_class_code
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

Line 226: AND HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'

222: AND HCASA.PARTY_SITE_ID=ZPTP.PARTY_ID
223: AND ZPTP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
224: --AND ZPTP.CUSTOMER_FLAG = 'Y'
225: AND ZPTP.PARTY_TAX_PROFILE_ID = HCA.OWNER_TABLE_ID
226: AND HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'
227: AND HCA.CLASS_CATEGORY = 'AR_GTA_TAXPAYER_TYPE'
228: AND SYSDATE BETWEEN HCA.START_DATE_ACTIVE AND NVL(HCA.END_DATE_ACTIVE,SYSDATE+1)
229: AND h.customer_trx_id = p_customer_trx_id;
230: EXCEPTION

Line 242: zx_party_tax_profile ZPTP,

238: INTO l_class_code
239: FROM ra_customer_trx_all h,
240: Hz_Parties RAC_BILL_PARTY,
241: Hz_Cust_Accounts RAC_BILL,
242: zx_party_tax_profile ZPTP,
243: hz_code_assignments HCA
244: WHERE h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID
245: AND rac_bill.party_id = RAC_BILL_PARTY.Party_Id
246: AND ZPTP.PARTY_ID = RAC_BILL_PARTY.Party_Id

Line 250: AND HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'

246: AND ZPTP.PARTY_ID = RAC_BILL_PARTY.Party_Id
247: AND ZPTP.PARTY_TYPE_CODE = 'THIRD_PARTY'
248: --AND ZPTP.CUSTOMER_FLAG = 'Y'
249: AND ZPTP.PARTY_TAX_PROFILE_ID = HCA.OWNER_TABLE_ID
250: AND HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'
251: AND HCA.CLASS_CATEGORY = 'AR_GTA_TAXPAYER_TYPE'
252: AND SYSDATE BETWEEN HCA.START_DATE_ACTIVE AND NVL(HCA.END_DATE_ACTIVE,SYSDATE+1)
253: AND h.customer_trx_id = p_customer_trx_id;
254: EXCEPTION

Line 3524: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;

3520: l_tax_regime_code zx_lines.tax_regime_code%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;

Line 3664: zx_party_tax_profile tax_prof

3660: party_tax_profile_id
3661: INTO
3662: l_party_tax_profile_id
3663: FROM
3664: zx_party_tax_profile tax_prof
3665: WHERE tax_prof.party_id = l_party_site_id
3666: AND tax_prof.party_type_code = 'THIRD_PARTY_SITE';
3667: EXCEPTION
3668: WHEN no_data_found THEN

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