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 RA_CUST_TRX_TYPES_ALL

Line 4487: RA_CUST_TRX_TYPES_ALL RCTT,

4483: CURSOR c_cm_inv_type_different
4484: IS
4485: SELECT JGTH.GTA_TRX_NUMBER, SOURCE
4486: FROM RA_CUSTOMER_TRX_ALL RCT,
4487: RA_CUST_TRX_TYPES_ALL RCTT,
4488: AR_GTA_TRX_HEADERS_ALL JGTH
4489: WHERE invoice_type is not null
4490: AND JGTH.ORG_ID = p_org_id
4491: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id

Line 4522: l_ar_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;

4518: l_fp_tax_registration_number ar_gta_trx_headers_all.FP_TAX_REGISTRATION_NUMBER%TYPE;
4519: l_org_id ar_gta_trx_headers_all.ORG_ID%TYPE;
4520: l_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4521: l_pre_trx_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4522: l_ar_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;
4523:
4524:
4525: BEGIN
4526: --logging for debug

Line 4582: FROM RA_CUST_TRX_TYPES_ALL RCTT

4578: THEN
4579: BEGIN
4580: SELECT RCTT.TYPE
4581: INTO l_ar_trx_type
4582: FROM RA_CUST_TRX_TYPES_ALL RCTT
4583: ,RA_CUSTOMER_TRX_ALL RCT
4584: ,AR_GTA_TRX_HEADERS_ALL JGTH
4585: WHERE JGTH.GTA_TRX_HEADER_ID = l_gta_trx_header_id
4586: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id