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.OZF_SETTLEMENT_DOC_PVT dependencies on AP_CHECKS

Line 1280: FROM ap_invoice_payments pay, ap_checks chk

1276: SET payment_status = (SELECT SUBSTRB(lkp.displayed_field,1,30)
1277: FROM ap_lookup_codes lkp
1278: where lkp.lookup_type = 'CHECK STATE'
1279: and lkp.lookup_code IN (select status_lookup_code
1280: FROM ap_invoice_payments pay, ap_checks chk
1281: WHERE pay.check_id = chk.check_id
1282: AND pay.invoice_payment_id = stlmnt_docs.settlement_id)),
1283: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
1284: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),

Line 1451: , ap_checks_all chk

1447: , oc.payment_method -- "payment_method"
1448: , sum(NVL(pay.discount_taken,0))
1449: , inv.invoice_amount
1450: FROM ap_invoice_payments_all pay
1451: , ap_checks_all chk
1452: , ap_invoices_all inv
1453: , ozf_claims_all oc
1454: WHERE pay.check_id = chk.check_id
1455: AND inv.invoice_id = pay.invoice_id