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_PMT_CALLOUT_PKG dependencies on IBY_FD_PAYMENTS_V

Line 738: FROM iby_fd_payments_v pmts,

734: l_api_name VARCHAR2(100);
735:
736: CURSOR c_relevant_checkrun_ids IS
737: SELECT distinct calling_app_doc_unique_ref1
738: FROM iby_fd_payments_v pmts,
739: iby_fd_docs_payable_v docs
740: WHERE pmts.payment_id = docs.payment_id
741: AND pmts.completed_pmts_group_id = p_completed_pmts_group_id
742: AND pmts.org_type = 'OPERATING_UNIT';

Line 747: FROM iby_fd_payments_v pmts,

743:
744:
745: CURSOR c_relevant_orgs(c_checkrun_id IN NUMBER) is
746: SELECT distinct pmts.org_id
747: FROM iby_fd_payments_v pmts,
748: iby_fd_docs_payable_v docs
749: WHERE pmts.payment_id = docs.payment_id
750: AND pmts.completed_pmts_group_id = p_completed_pmts_group_id
751: AND pmts.org_type = 'OPERATING_UNIT'

Line 791: iby_fd_payments_v ibypmts

787: ibydocs.calling_app_doc_unique_ref1 ref1,
788: ibydocs.calling_app_doc_unique_ref2 ref2,
789: ibydocs.calling_app_doc_unique_ref3 ref3
790: FROM iby_fd_docs_payable_v ibydocs,
791: iby_fd_payments_v ibypmts
792: WHERE ibypmts.org_type = 'OPERATING_UNIT'
793: AND ibypmts.payment_id = ibydocs.payment_id
794: AND ibypmts.completed_pmts_group_id = p_completed_group_id
795: AND ibypmts.org_id = p_current_org_id

Line 836: iby_fd_payments_v ibypmts,

832: ps.payment_num
833: FROM ap_payment_schedules_all ps,
834: ap_invoices_all inv,
835: ap_selected_invoices_all si,
836: iby_fd_payments_v ibypmts,
837: iby_fd_docs_payable_v ibydocs
838: WHERE si.checkrun_name = p_checkrun_name
839: AND si.payment_num = ps.payment_num
840: AND si.invoice_id = ps.invoice_id

Line 904: FROM iby_fd_payments_v pmts,

900:
901: /* --Bug 5115310
902: SELECT calling_app_doc_unique_ref1
903: INTO l_checkrun_id
904: FROM iby_fd_payments_v pmts,
905: iby_fd_docs_payable_v docs
906: WHERE pmts.payment_id = docs.payment_id
907: AND pmts.completed_pmts_group_id = p_completed_pmts_group_id
908: AND pmts.org_type = 'OPERATING_UNIT'

Line 1205: iby_fd_payments_v ibypmts,

1201: ibypmts.supplier_site_id,
1202: ibypmts.relationship_id
1203: FROM ap_invoices_all orig,
1204: ap_supplier_sites_all aps, -- bug 7673570
1205: iby_fd_payments_v ibypmts,
1206: ap_selected_invoices_all new,
1207: iby_fd_docs_payable_v ibydocs,
1208: fnd_currencies fcinv
1209: /* Bug 6950891. Added TO_CHAR */

Line 1306: iby_fd_payments_v ibypmts,

1302: l_current_org_id
1303: FROM
1304: po_vendors pv,
1305: ap_invoices_all orig,
1306: iby_fd_payments_v ibypmts,
1307: iby_fd_docs_payable_v ibydocs,
1308: ap_selected_invoices new,
1309: fnd_currencies fcinv
1310: /* Bug 6950891. Added TO_CHAR */

Line 1410: iby_fd_payments_v ibypmts,

1406: FROM ap_invoices_all orig,
1407: ap_selected_invoices_all new,
1408: ap_supplier_sites_all aps, -- bug 7673570
1409: fnd_currencies fcinv,
1410: iby_fd_payments_v ibypmts,
1411: iby_fd_docs_payable_v ibydocs
1412: /* Bug 6950891. Added TO_CHAR */
1413: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)
1414: AND ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(new.invoice_id)

Line 1451: iby_fd_payments_v ibypmts,

1447: SYSDATE,
1448: l_checkrun_name
1449: FROM ap_invoices_all orig,
1450: ap_selected_invoices_all new,
1451: iby_fd_payments_v ibypmts,
1452: iby_fd_docs_payable_v ibydocs
1453: /* Bug 6950891. Added TO_CHAR */
1454: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)
1455: AND ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(new.invoice_id)

Line 1677: FROM iby_fd_payments_v iby,

1673: aps.vendor_id,
1674: aps.vendor_site_code,
1675: iby.supplier_site_id,
1676: iby.relationship_id
1677: FROM iby_fd_payments_v iby,
1678: po_vendors pv,
1679: ce_bank_acct_uses_all ce,
1680: ce_bank_accounts ceb,
1681: ap_supplier_sites_all aps -- 7673570

Line 1767: iby_fd_payments_v ibypmts

1763: /* Bug 6950891. Added TO_CHAR */
1764: AND (TO_CHAR(ASI.invoice_id), TO_CHAR(ASI.payment_num)) in
1765: (select calling_app_doc_unique_ref2, calling_app_doc_unique_ref3
1766: FROM iby_fd_docs_payable_v ibydocs,
1767: iby_fd_payments_v ibypmts
1768: WHERE ibydocs.payment_id = ibypmts.payment_id
1769: and ibypmts.org_type = 'OPERATING_UNIT'
1770: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
1771: AND ibypmts.org_id = l_current_org_id);

Line 1796: iby_fd_payments_v ibypmts

1792: AND (TO_CHAR(AATD.invoice_id), TO_CHAR(AATD.payment_num)) in
1793: /* Bug 5383066, calling_app_doc_unique_ref3 should be used for payment_num*/
1794: (select calling_app_doc_unique_ref2, calling_app_doc_unique_ref3
1795: FROM iby_fd_docs_payable_v ibydocs,
1796: iby_fd_payments_v ibypmts
1797: WHERE ibydocs.payment_id = ibypmts.payment_id
1798: and ibypmts.org_type = 'OPERATING_UNIT'
1799: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
1800: AND ibypmts.org_id = l_current_org_id);

Line 2126: iby_fd_payments_v ibypmts,

2122: aps.vendor_id,
2123: aps.vendor_site_code,
2124: ibypmts.supplier_site_id
2125: FROM
2126: iby_fd_payments_v ibypmts,
2127: iby_fd_docs_payable_v ibydocs,
2128: ap_selected_invoices_all SI,
2129: fnd_currencies FORE,
2130: ap_payment_schedules_all PS,

Line 2331: iby_fd_payments_v ibypmts,

2327: AND ibydocs.calling_app_doc_unique_ref3 = to_char(si1.payment_num))
2328: WHERE (ps1.invoice_id, ps1.payment_num) in
2329: (SELECT SI3.invoice_id, SI3.payment_num
2330: FROM ap_selected_invoices_all SI3,
2331: iby_fd_payments_v ibypmts,
2332: iby_fd_docs_payable_v ibydocs,
2333: ap_invoices_all AI
2334: WHERE SI3.checkrun_name = l_checkrun_name
2335: AND ibydocs.calling_app_doc_unique_ref1 = to_char(si3.checkrun_id)

Line 2366: iby_fd_payments_v ibypmts

2362: nvl(inv1.amount_paid,0) + sum(ibydocs.payment_amount),
2363: nvl(inv1.discount_amount_taken,0) + nvl(sum(ibydocs.payment_curr_discount_taken),0),
2364: AP_INVOICES_UTILITY_PKG.get_payment_status( inv1.invoice_id )
2365: FROM iby_fd_docs_payable_v ibydocs,
2366: iby_fd_payments_v ibypmts
2367: WHERE ibypmts.org_type = 'OPERATING_UNIT'
2368: AND ibypmts.payment_id = ibydocs.payment_id
2369: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
2370: AND ibypmts.org_id = l_current_org_id

Line 2380: iby_fd_payments_v ibypmts

2376: )
2377: WHERE invoice_id IN
2378: (SELECT ibydocs.calling_app_doc_unique_ref2
2379: FROM iby_fd_docs_payable_v ibydocs,
2380: iby_fd_payments_v ibypmts
2381: WHERE ibypmts.payment_id = ibydocs.payment_id
2382: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
2383: and ibypmts.org_type = 'OPERATING_UNIT'
2384: AND ibypmts.org_id = l_current_org_id)

Line 2473: iby_fd_payments_v ibypmts

2469: and (TO_CHAR(invoice_id), TO_CHAR(payment_num)) in
2470: (select ibydocs.calling_app_doc_unique_ref2,
2471: ibydocs.calling_app_doc_unique_ref3
2472: from iby_fd_docs_payable_v ibydocs,
2473: iby_fd_payments_v ibypmts
2474: where ibypmts.payment_id = ibydocs.payment_id
2475: and ibypmts.org_type = 'OPERATING_UNIT'
2476: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
2477: AND ibypmts.org_id = l_current_org_id);

Line 2496: FROM iby_fd_payments_v

2492:
2493:
2494: SELECT COUNT(*)
2495: INTO l_iby_check_count
2496: FROM iby_fd_payments_v
2497: WHERE completed_pmts_group_id = p_completed_pmts_group_id;
2498:
2499: SELECT COUNT(*)
2500: INTO l_iby_docs_count