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.AP_AUTOSELECT_PKG dependencies on IBY_FD_DOCS_PAYABLE_V

Line 6168: from iby_fd_docs_payable_v

6164: end;
6165:
6166: Select count(1) --Bug 14336393
6167: into l_fd_count
6168: from iby_fd_docs_payable_v
6169: where calling_app_doc_unique_ref1 = p_checkrun_id
6170: and calling_app_id = 200;
6171:
6172: if (l_psr_id is not null and l_fd_count <> 0) then

Line 6553: iby_fd_docs_payable_v ibydocs

6549: , asi.original_invoice_id
6550: , asi.original_payment_num
6551: , asi.payment_grouping_number
6552: FROM ap_selected_invoices_all ASI,
6553: iby_fd_docs_payable_v ibydocs
6554: WHERE checkrun_id = l_checkrun_id
6555: AND ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(ASI.checkrun_id)
6556: AND ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(ASI.invoice_id)
6557: AND ibydocs.calling_app_doc_unique_ref3 = TO_CHAR(ASI.payment_num)

Line 6572: from iby_fd_docs_payable_v

6568: END IF;
6569:
6570: select calling_app_doc_unique_ref1
6571: into l_checkrun_id
6572: from iby_fd_docs_payable_v
6573: where rejected_docs_group_id = p_rejected_docs_group_id
6574: and rownum = 1;
6575:
6576: l_debug_info := 'checkrun_id = ' || l_checkrun_id;

Line 6622: iby_fd_docs_payable_v ibydocs

6618: -- of docs to be removed and safe to remove.
6619:
6620: SELECT count(*) INTO l_count
6621: FROM ap_selected_invoices_all ASI,
6622: iby_fd_docs_payable_v ibydocs
6623: WHERE ASI.checkrun_id = l_checkrun_id
6624: AND ASI.invoice_id <> rec_sel_invs.invoice_id
6625: AND ( ( rec_sel_invs.original_invoice_id IS NULL -- standard schedule
6626: AND ASI.original_invoice_id = rec_sel_invs.invoice_id