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 CE_BANK_ACCOUNTS

Line 227: CE_BANK_ACCOUNTS CBA

223: INTO V_AMOUNT2
224: FROM
225: GL_JE_HEADERS GLH,
226: GL_JE_LINES GLL,
227: CE_BANK_ACCOUNTS CBA
228: WHERE GLH.JE_HEADER_ID = GLL.JE_HEADER_ID
229: AND GLH.LEDGER_ID = GLL.LEDGER_ID
230: AND GLL.LEDGER_ID = LP_SET_OF_BOOKS_ID
231: AND CBA.ASSET_CODE_COMBINATION_ID = GLL.CODE_COMBINATION_ID

Line 252: CE_BANK_ACCOUNTS CBA

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
253: WHERE ACRH.CASH_RECEIPT_ID = ACR.CASH_RECEIPT_ID
254: AND ACR.REMITTANCE_BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID
255: AND HCA.PARTY_ID = hp.party_id (+)
256: AND ACR.PAY_FROM_CUSTOMER = hca.cust_account_id (+)

Line 280: CE_BANK_ACCOUNTS CBA

276: AP_INVOICE_DISTRIBUTIONS_ALL APID,
277: AP_INVOICE_LINES_ALL APLA,
278: AP_INVOICES_ALL API,
279: PO_VENDORS POV,
280: CE_BANK_ACCOUNTS CBA
281: WHERE API.INVOICE_ID = APID.INVOICE_ID
282: AND APLA.INVOICE_ID = APID.INVOICE_ID
283: AND APLA.LINE_NUMBER = APID.INVOICE_LINE_NUMBER
284: AND API.VENDOR_ID = POV.VENDOR_ID

Line 304: CE_BANK_ACCOUNTS CBA

300: INTO V_AMOUNT1
301: FROM
302: AP_INVOICE_PAYMENTS_ALL AIP,
303: AP_CHECKS_ALL APC,
304: CE_BANK_ACCOUNTS CBA
305: WHERE AIP.CHECK_ID = APC.CHECK_ID
306: AND APC.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID
307: AND APC.STATUS_LOOKUP_CODE IN ( LV_NEGOT_LOOKUP , LV_CLEAR_LOOKUP , LV_VOIDED_LOOKUP , LV_REC_UNACC_LOOKUP , LV_REC_LOOKUP , LV_CLEAR_UNACC_LOOKUP )
308: AND CBA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID