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.JA_JAINARDR_XMLP_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 18: RA_CUST_TRX_LINE_GL_DIST_ALL B

14: ,1))
15: FROM
16: RA_CUSTOMER_TRX_ALL A,
17: AR_PAYMENT_SCHEDULES_ALL C,
18: RA_CUST_TRX_LINE_GL_DIST_ALL B
19: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
20: AND TRUNC(C.GL_DATE) < TRUNC(P_START_DATE)
21: AND A.INVOICE_CURRENCY_CODE = CURR_CODE
22: AND A.COMPLETE_FLAG = 'Y'

Line 204: RA_CUST_TRX_LINE_GL_DIST_ALL B

200: INTO V_CRE_MEMO_AMT,V_CRE_MEMO_FUNC_AMT
201: FROM
202: RA_CUSTOMER_TRX_ALL A,
203: AR_PAYMENT_SCHEDULES_ALL C,
204: RA_CUST_TRX_LINE_GL_DIST_ALL B
205: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
206: AND TRUNC(C.GL_DATE) < TRUNC(P_START_DATE)
207: AND A.INVOICE_CURRENCY_CODE = CURR_CODE
208: AND A.COMPLETE_FLAG = 'Y'

Line 304: RA_CUST_TRX_LINE_GL_DIST_ALL B

300: ,1))
301: FROM
302: RA_CUSTOMER_TRX_ALL A,
303: AR_PAYMENT_SCHEDULES_ALL C,
304: RA_CUST_TRX_LINE_GL_DIST_ALL B
305: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID2
306: AND TRUNC(C.GL_DATE) <= TRUNC(P_END_DATE)
307: AND A.INVOICE_CURRENCY_CODE = CURR_CODE1
308: AND A.COMPLETE_FLAG = 'Y'

Line 490: RA_CUST_TRX_LINE_GL_DIST_ALL B

486: INTO V_CRE_MEMO_AMT,V_CRE_MEMO_FUNC_AMT
487: FROM
488: RA_CUSTOMER_TRX_ALL A,
489: AR_PAYMENT_SCHEDULES_ALL C,
490: RA_CUST_TRX_LINE_GL_DIST_ALL B
491: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID2
492: AND TRUNC(C.GL_DATE) <= TRUNC(P_END_DATE)
493: AND A.INVOICE_CURRENCY_CODE = CURR_CODE1
494: AND A.COMPLETE_FLAG = 'Y'