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.XTR_AUTO_RECONCILIATION dependencies on CE_STATEMENT_LINES

Line 457: SELECT effective_date FROM ce_statement_lines WHERE statement_line_id IN (

453: where DEAL_NUMBER = l_deal_no
454: and TRANSACTION_NUMBER = l_trans_no;
455: -- Created cursor Bug 4226409
456: CURSOR SETTLE_DATE(p_rec_ref NUMBER) is
457: SELECT effective_date FROM ce_statement_lines WHERE statement_line_id IN (
458: SELECT statement_line_id FROM ce_statement_reconcils_all WHERE reference_id in
459: (SELECT settlement_summary_id FROM xtr_settlement_summary WHERE settlement_number
460: IN (SELECT settlement_number FROM xtr_deal_date_amounts WHERE reconciled_reference = p_rec_ref )));
461: /* select VALUE_DATE