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_JAINBBR_XMLP_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 188: LV_CLEAR_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;

184: LV_PAY_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
185: LV_RCV_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
186: LV_PAY_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
187: LV_RCV_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
188: LV_CLEAR_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
189: LV_REMIT_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
190: LV_CONFIRM_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
191: LV_REV_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
192: LV_NEGOT_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

Line 189: LV_REMIT_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;

185: LV_RCV_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
186: LV_PAY_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
187: LV_RCV_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
188: LV_CLEAR_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
189: LV_REMIT_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
190: LV_CONFIRM_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
191: LV_REV_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
192: LV_NEGOT_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
193: LV_CLEAR_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

Line 190: LV_CONFIRM_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;

186: LV_PAY_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
187: LV_RCV_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
188: LV_CLEAR_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
189: LV_REMIT_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
190: LV_CONFIRM_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
191: LV_REV_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
192: LV_NEGOT_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
193: LV_CLEAR_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
194: LV_VOIDED_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

Line 191: LV_REV_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;

187: LV_RCV_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
188: LV_CLEAR_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
189: LV_REMIT_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
190: LV_CONFIRM_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
191: LV_REV_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
192: LV_NEGOT_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
193: LV_CLEAR_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
194: LV_VOIDED_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
195: LV_REC_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

Line 248: AR_CASH_RECEIPT_HISTORY_ALL ACRH,

244: ,0) * NVL(ACRH.EXCHANGE_RATE
245: ,1)))
246: INTO V_AMOUNT1
247: FROM
248: AR_CASH_RECEIPT_HISTORY_ALL ACRH,
249: AR_CASH_RECEIPTS_ALL ACR,
250: HZ_PARTIES HP,
251: HZ_CUST_ACCOUNTS HCA,
252: CE_BANK_ACCOUNTS CBA

Line 264: AR_CASH_RECEIPT_HISTORY_ALL INCRH

260: OR ( ACRH.CASH_RECEIPT_HISTORY_ID IN (
261: SELECT
262: MIN(INCRH.CASH_RECEIPT_HISTORY_ID)
263: FROM
264: AR_CASH_RECEIPT_HISTORY_ALL INCRH
265: WHERE INCRH.CASH_RECEIPT_ID = ACR.CASH_RECEIPT_ID
266: AND INCRH.STATUS <> LV_REV_STATUS ) ) )
267: AND CBA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID
268: AND ACRH.GL_DATE < V_BASE_DATE