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_ARTRX_PROC dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 949: , Ra_Cust_Trx_Line_Gl_Dist_All gd

945: FROM
946: ra_customer_trx_all h
947: , ra_cust_trx_types_all ctt
948: , ra_batches_all b
949: , Ra_Cust_Trx_Line_Gl_Dist_All gd
950: , Hz_Parties RAC_BILL_PARTY
951: , Hz_Cust_Accounts RAC_BILL
952: , GL_PERIODS GP
953: WHERE h.complete_flag = ''Y''

Line 2073: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;

2069: l_dul_flag NUMBER := 0;
2070:
2071: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2072: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2073: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2074: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2075: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2076: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2077: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;

Line 2490: Ra_Cust_Trx_Line_Gl_Dist_All gd,

2486: l_period_name
2487: FROM ra_customer_trx_all h,
2488: ra_cust_trx_types_all ctt,
2489: ra_batches_all b,
2490: Ra_Cust_Trx_Line_Gl_Dist_All gd,
2491: Hz_Parties RAC_BILL_PARTY,
2492: Hz_Cust_Accounts RAC_BILL,
2493: GL_PERIODS GP -- period
2494: WHERE h.complete_flag = 'Y'