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.JG_TAXID_VAL_PKG dependencies on RA_CUSTOMERS_INTERFACE

Line 143: SELECT I.JGZZ_FISCAL_CODE -- RA_CUSTOMERS_INTERFACE

139: AND hzc.CUST_ACCOUNT_ID <> nvl(p_record_id,0)
140: AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code
141: -- Modified for Countries w/o GDF
142: UNION
143: SELECT I.JGZZ_FISCAL_CODE -- RA_CUSTOMERS_INTERFACE
144: FROM RA_CUSTOMERS_INTERFACE I
145: WHERE ( I.CUSTOMER_NAME <> p_entity_name
146: OR I.ORIG_SYSTEM_CUSTOMER_REF <> p_orig_system_ref)
147: AND I.JGZZ_FISCAL_CODE = p_taxpayer_id

Line 144: FROM RA_CUSTOMERS_INTERFACE I

140: AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code
141: -- Modified for Countries w/o GDF
142: UNION
143: SELECT I.JGZZ_FISCAL_CODE -- RA_CUSTOMERS_INTERFACE
144: FROM RA_CUSTOMERS_INTERFACE I
145: WHERE ( I.CUSTOMER_NAME <> p_entity_name
146: OR I.ORIG_SYSTEM_CUSTOMER_REF <> p_orig_system_ref)
147: AND I.JGZZ_FISCAL_CODE = p_taxpayer_id
148: AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code

Line 198: -- Checking for Duplicate Tax ID in RA_CUSTOMERS and RA_CUSTOMERS_INTERFACE Tables

194: -- Checking for Tax ID used by a different Company
195: -- Tax payer id for Company is done by XLE
196: -- stubbed out because of ap_bank_branches
197:
198: -- Checking for Duplicate Tax ID in RA_CUSTOMERS and RA_CUSTOMERS_INTERFACE Tables
199:
200: ELSIF p_calling_program = 'RACUST' THEN
201: OPEN CHECK_UNIQUE_TAXID_AR1;
202: FETCH CHECK_UNIQUE_TAXID_AR1 INTO l_taxid;

Line 243: SELECT I.CUST_TAX_REFERENCE -- RA_CUSTOMERS_INTERFACE

239: AND AR.CUSTOMER_ID <> nvl(p_record_id,0)
240: AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code -- Modified for Countries w/o GDF
241: UNION
242:
243: SELECT I.CUST_TAX_REFERENCE -- RA_CUSTOMERS_INTERFACE
244: FROM RA_CUSTOMERS_INTERFACE I
245: WHERE ( I.CUSTOMER_NAME <> p_entity_name
246: OR I.ORIG_SYSTEM_CUSTOMER_REF <> p_orig_system_ref)
247: AND I.CUST_TAX_REFERENCE = p_tax_reg_num

Line 244: FROM RA_CUSTOMERS_INTERFACE I

240: AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code -- Modified for Countries w/o GDF
241: UNION
242:
243: SELECT I.CUST_TAX_REFERENCE -- RA_CUSTOMERS_INTERFACE
244: FROM RA_CUSTOMERS_INTERFACE I
245: WHERE ( I.CUSTOMER_NAME <> p_entity_name
246: OR I.ORIG_SYSTEM_CUSTOMER_REF <> p_orig_system_ref)
247: AND I.CUST_TAX_REFERENCE = p_tax_reg_num
248: AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code -- Modified for Countries w/o GDF

Line 287: -- and RA_CUSTOMERS_INTERFACE Tables

283: END IF;
284: CLOSE CHECK_UNIQUE_TAX_REG_NUM_AP;
285:
286: -- Checking for Duplicate Tax Registration Number in RA_CUSTOMERS
287: -- and RA_CUSTOMERS_INTERFACE Tables
288:
289: ELSIF p_calling_program = 'RACUST' THEN
290: OPEN CHECK_UNIQUE_TAX_REG_NUM_AR1;
291: FETCH CHECK_UNIQUE_TAX_REG_NUM_AR1 INTO l_tax_reg_num;