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 AR_CASH_RECEIPTS_ALL

Line 65: AR_CASH_RECEIPTS_ALL A

61: SUM(A.AMOUNT) SUM_AMOUNT,
62: SUM(A.AMOUNT * NVL(A.EXCHANGE_RATE
63: ,1.00)) SUM_AMOUNT_EXCHANGE
64: FROM
65: AR_CASH_RECEIPTS_ALL A
66: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID
67: AND A.CURRENCY_CODE = CURR_CODE
68: AND A.ORG_ID = P_ORG_ID
69: AND EXISTS (

Line 83: AR_CASH_RECEIPTS_ALL A,

79: SUM(A.AMOUNT) SUM_AMOUNT,
80: SUM(A.AMOUNT * NVL(A.EXCHANGE_RATE
81: ,1.00)) SUM_AMOUNT_EXCHANGE
82: FROM
83: AR_CASH_RECEIPTS_ALL A,
84: AR_CASH_RECEIPT_HISTORY_ALL B
85: WHERE A.CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
86: AND A.PAY_FROM_CUSTOMER = CUSTOMER_ID
87: AND TRUNC(B.GL_DATE) < TRUNC(P_START_DATE)

Line 119: AR_CASH_RECEIPTS_ALL C,

115: SUM(E.AMOUNT_CR) SUM_AMOUNT,
116: SUM(E.ACCTD_AMOUNT_CR) SUM_EXCHANGE_AMOUNT
117: FROM
118: RA_CUSTOMER_TRX_ALL B,
119: AR_CASH_RECEIPTS_ALL C,
120: AR_RECEIVABLE_APPLICATIONS_ALL D,
121: AR_DISTRIBUTIONS_ALL E
122: WHERE B.CUSTOMER_TRX_ID = D.APPLIED_CUSTOMER_TRX_ID
123: AND C.CASH_RECEIPT_ID = D.CASH_RECEIPT_ID

Line 136: AR_CASH_RECEIPTS_ALL C,

132: SUM(E.AMOUNT_DR) SUM_AMOUNT,
133: SUM(E.ACCTD_AMOUNT_DR) SUM_EXCHANGE_AMOUNT
134: FROM
135: RA_CUSTOMER_TRX_ALL B,
136: AR_CASH_RECEIPTS_ALL C,
137: AR_RECEIVABLE_APPLICATIONS_ALL D,
138: AR_DISTRIBUTIONS_ALL E
139: WHERE B.CUSTOMER_TRX_ID = D.APPLIED_CUSTOMER_TRX_ID
140: AND C.CASH_RECEIPT_ID = D.CASH_RECEIPT_ID

Line 153: AR_CASH_RECEIPTS_ALL A,

149: SUM(C.AMOUNT_APPLIED) SUM_AMOUNT,
150: SUM(C.AMOUNT_APPLIED * NVL(A.EXCHANGE_RATE
151: ,1.00)) SUM_AMOUNT_EXCHANGE
152: FROM
153: AR_CASH_RECEIPTS_ALL A,
154: AR_CASH_RECEIPT_HISTORY_ALL B,
155: AR_RECEIVABLE_APPLICATIONS_ALL C
156: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID
157: AND TRUNC(B.GL_DATE) < TRUNC(P_START_DATE)

Line 351: AR_CASH_RECEIPTS_ALL A

347: SUM(A.AMOUNT) SUM_AMOUNT,
348: SUM(A.AMOUNT * NVL(A.EXCHANGE_RATE
349: ,1.00)) SUM_AMOUNT_EXCHANGE
350: FROM
351: AR_CASH_RECEIPTS_ALL A
352: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID2
353: AND A.CURRENCY_CODE = CURR_CODE1
354: AND A.ORG_ID = P_ORG_ID
355: AND EXISTS (

Line 369: AR_CASH_RECEIPTS_ALL A,

365: SUM(A.AMOUNT) SUM_AMOUNT,
366: SUM(A.AMOUNT * NVL(A.EXCHANGE_RATE
367: ,1.00)) SUM_AMOUNT_EXCHANGE
368: FROM
369: AR_CASH_RECEIPTS_ALL A,
370: AR_CASH_RECEIPT_HISTORY_ALL B
371: WHERE A.CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
372: AND A.PAY_FROM_CUSTOMER = CUSTOMER_ID2
373: AND TRUNC(B.GL_DATE) <= TRUNC(P_END_DATE)

Line 405: AR_CASH_RECEIPTS_ALL C,

401: SUM(E.AMOUNT_CR) SUM_AMOUNT,
402: SUM(E.ACCTD_AMOUNT_CR) SUM_EXCHANGE_AMOUNT
403: FROM
404: RA_CUSTOMER_TRX_ALL B,
405: AR_CASH_RECEIPTS_ALL C,
406: AR_RECEIVABLE_APPLICATIONS_ALL D,
407: AR_DISTRIBUTIONS_ALL E
408: WHERE B.CUSTOMER_TRX_ID = D.APPLIED_CUSTOMER_TRX_ID
409: AND C.CASH_RECEIPT_ID = D.CASH_RECEIPT_ID

Line 422: AR_CASH_RECEIPTS_ALL C,

418: SUM(E.AMOUNT_DR) SUM_AMOUNT,
419: SUM(E.ACCTD_AMOUNT_DR) SUM_EXCHANGE_AMOUNT
420: FROM
421: RA_CUSTOMER_TRX_ALL B,
422: AR_CASH_RECEIPTS_ALL C,
423: AR_RECEIVABLE_APPLICATIONS_ALL D,
424: AR_DISTRIBUTIONS_ALL E
425: WHERE B.CUSTOMER_TRX_ID = D.APPLIED_CUSTOMER_TRX_ID
426: AND C.CASH_RECEIPT_ID = D.CASH_RECEIPT_ID

Line 439: AR_CASH_RECEIPTS_ALL A,

435: SUM(C.AMOUNT_APPLIED) SUM_AMOUNT,
436: SUM(C.AMOUNT_APPLIED * NVL(A.EXCHANGE_RATE
437: ,1.00)) SUM_AMOUNT_EXCHANGE
438: FROM
439: AR_CASH_RECEIPTS_ALL A,
440: AR_CASH_RECEIPT_HISTORY_ALL B,
441: AR_RECEIVABLE_APPLICATIONS_ALL C
442: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID2
443: AND TRUNC(B.GL_DATE) <= TRUNC(P_END_DATE)