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 AR_GTA_TYPE_MAPPINGS

Line 192: ,ar_gta_type_mappings jgtm

188: INTO
189: l_invoice_type
190: FROM
191: ar_gta_tax_limits_all jgtla
192: ,ar_gta_type_mappings jgtm
193: ,ra_customer_trx_all rcta
194: WHERE rcta.customer_trx_id = p_customer_trx_id
195: AND rcta.cust_trx_type_id = jgtm.transaction_type_id
196: AND jgtm.limitation_id = jgtla.limitation_id

Line 4458: ,ar_gta_type_mappings JGTM

4454: AND JGTH.ORG_ID = p_org_id
4455: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id
4456: AND NOT EXISTS (SELECT JGTL.Limitation_Id
4457: FROM ar_gta_tax_limits_all JGTL
4458: ,ar_gta_type_mappings JGTM
4459: WHERE JGTL.ORG_ID = JGTH.Org_Id
4460: AND JGTL.FP_TAX_REGISTRATION_NUMBER = JGTH.FP_TAX_REGISTRATION_NUMBER
4461: AND JGTM.Limitation_Id = JGTL.LIMITATION_ID
4462: AND JGTM.TRANSACTION_TYPE_ID = RCT.CUST_TRX_TYPE_ID);

Line 4476: ,ar_gta_type_mappings JGTM

4472: AND JGTH.ORG_ID = p_org_id
4473: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id
4474: AND EXISTS (SELECT JGTL.Limitation_Id
4475: FROM ar_gta_tax_limits_all JGTL
4476: ,ar_gta_type_mappings JGTM
4477: WHERE JGTL.ORG_ID = JGTH.Org_Id
4478: AND JGTL.FP_TAX_REGISTRATION_NUMBER = JGTH.FP_TAX_REGISTRATION_NUMBER
4479: AND JGTM.Limitation_Id = JGTL.LIMITATION_ID
4480: AND JGTM.TRANSACTION_TYPE_ID = RCT.CUST_TRX_TYPE_ID);

Line 4558: FROM ar_gta_type_mappings JGTM

4554: AND JGTL.ORG_ID = l_org_id
4555: AND JGTL.FP_TAX_REGISTRATION_NUMBER = l_fp_tax_registration_number
4556: AND RCT.CUST_TRX_TYPE_ID in
4557: (SELECT JGTM.TRANSACTION_TYPE_ID
4558: FROM ar_gta_type_mappings JGTM
4559: WHERE JGTM.Limitation_Id = JGTL.LIMITATION_ID)
4560: AND (JGTL.invoice_type IN ('0', '2') OR
4561: (JGTL.invoice_type = '1' AND NOT EXISTS
4562: ( SELECT *

Line 4640: FROM ar_gta_type_mappings JGTM

4636: AND JGTL.FP_TAX_REGISTRATION_NUMBER =
4637: JGTH.FP_TAX_REGISTRATION_NUMBER
4638: AND RCT.CUST_TRX_TYPE_ID in
4639: (SELECT JGTM.TRANSACTION_TYPE_ID
4640: FROM ar_gta_type_mappings JGTM
4641: WHERE JGTM.Limitation_Id = JGTL.LIMITATION_ID)
4642: AND (JGTL.invoice_type IN ('0', '2') OR
4643: (JGTL.invoice_type = '1' AND NOT EXISTS
4644: ( SELECT *