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.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_AR_CASH_RECEIPTS_ALL

Line 295: FROM jai_ar_cash_receipts_all

291: --Added by Wenqiong begin
292: CURSOR get_cash_receipt_gl_date_cur IS
293: SELECT
294: GL_DATE
295: FROM jai_ar_cash_receipts_all
296: WHERE cash_receipt_id = pn_document_id;
297: --Added by Wenqiong end
298:
299: --Added by Qiong for bug13555753 begin

Line 1923: jai_ar_cash_receipts_all jacr,

1919: ,jacr.location_id location_id
1920: ,jacr.service_type_code service_type_code
1921: ,acra.reversal_date reversal_date --Added by Qiong for bug13555753
1922: from ar_cash_receipts_all acra,
1923: jai_ar_cash_receipts_all jacr,
1924: hz_parties hzp,
1925: hz_cust_accounts hca
1926: WHERE acra.cash_receipt_id = jacr.cash_receipt_id
1927: AND jacr.document_type = 'Service'

Line 1956: jai_ar_cash_receipts_all jacr,

1952: ,acra.set_of_books_id
1953: /*Added by Qinglei on 05-Jan-2012 for bug#13556198 end*/
1954: from ar_receivable_applications_all araa,
1955: ar_cash_receipts_all acra,
1956: jai_ar_cash_receipts_all jacr,
1957: hz_parties hzp,
1958: hz_cust_accounts hca
1959: WHERE araa.cash_receipt_id = acra.cash_receipt_id
1960: AND acra.cash_receipt_id = jacr.cash_receipt_id