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

Line 725: FROM AR_CASH_RECEIPT_HISTORY_ALL

721: AND App.applied_customer_trx_id = pn_customer_trx_id
722: AND App.Gl_Date <= pd_period_end_date --parameter:pd_period_end_date
723: -- Choli updated, fix bug 12635156
724: AND (SELECT status
725: FROM AR_CASH_RECEIPT_HISTORY_ALL
726: WHERE cash_receipt_id = App.cash_receipt_id
727: AND cash_receipt_history_id =
728: (SELECT max(cash_receipt_history_id)
729: FROM AR_CASH_RECEIPT_HISTORY_ALL

Line 729: FROM AR_CASH_RECEIPT_HISTORY_ALL

725: FROM AR_CASH_RECEIPT_HISTORY_ALL
726: WHERE cash_receipt_id = App.cash_receipt_id
727: AND cash_receipt_history_id =
728: (SELECT max(cash_receipt_history_id)
729: FROM AR_CASH_RECEIPT_HISTORY_ALL
730: WHERE cash_receipt_id = App.cash_receipt_id
731: AND gl_date < pd_period_end_date)) = 'CLEARED'
732: ------------------------------------
733: )