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.FV_FACTS_TBAL_TRANSACTIONS dependencies on AP_CHECKS_ALL

Line 2235: From ap_checks_all apc,

2231:
2232: Cursor Pay_Pay is
2233: Select Distinct api.invoice_num,
2234: apc.check_date,api.created_by,api.creation_date
2235: From ap_checks_all apc,
2236: ap_invoices_all api,
2237: ap_invoice_payments_all apip
2238: where to_char(apc.check_id) = p_reference3
2239: and to_char(api.invoice_id) = p_reference2

Line 2290: FROM ap_checks_all

2286: -- Bug 2606958 End
2287:
2288: Cursor Pay_Treas_Check is
2289: SELECT void_date, checkrun_name
2290: FROM ap_checks_all
2291: WHERE check_id = p_reference3;
2292:
2293: Cursor Pay_Treas_Void is
2294: SELECT creation_date, created_by

Line 2311: FROM ap_checks_all

2307: WHERE to_char(ftc.treasury_confirmation_id) = p_reference1;
2308:
2309: Cursor Pay_Pay_Check is
2310: SELECT void_date, check_date
2311: FROM ap_checks_all
2312: WHERE check_id = p_reference3;
2313:
2314: Cursor Pay_Pay_Void is
2315: SELECT NVL(MAX(invoice_payment_id),0)

Line 2332: FROM ap_checks_all apc,

2328: AND apip.invoice_payment_id = p_reference9;
2329:
2330: Cursor Pay_Pay_Non_Void is
2331: SELECT api.invoice_num, apc.creation_date, apc.created_by
2332: FROM ap_checks_all apc,
2333: ap_invoices_all api,
2334: ap_invoice_payments_all apip
2335: WHERE to_char(apc.check_id) = p_reference3
2336: AND to_char(api.invoice_id) = p_reference2