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 835: FROM iby_fd_payments_v pmts,

831:
832:
833: CURSOR c_relevant_checkrun_ids IS
834: SELECT distinct calling_app_doc_unique_ref1
835: FROM iby_fd_payments_v pmts,
836: iby_fd_docs_payable_v docs
837: WHERE pmts.payment_id = docs.payment_id
838: AND pmts.completed_pmts_group_id = p_completed_pmts_group_id
839: AND pmts.org_type = 'OPERATING_UNIT';

Line 844: FROM iby_fd_payments_v pmts,

840:
841:
842: CURSOR c_relevant_orgs(c_checkrun_id IN NUMBER) is
843: SELECT distinct pmts.org_id
844: FROM iby_fd_payments_v pmts,
845: iby_fd_docs_payable_v docs
846: WHERE pmts.payment_id = docs.payment_id
847: AND pmts.completed_pmts_group_id = p_completed_pmts_group_id
848: AND pmts.org_type = 'OPERATING_UNIT'

Line 888: iby_fd_payments_v ibypmts

884: ibydocs.calling_app_doc_unique_ref1 ref1,
885: ibydocs.calling_app_doc_unique_ref2 ref2,
886: ibydocs.calling_app_doc_unique_ref3 ref3
887: FROM iby_fd_docs_payable_v ibydocs,
888: iby_fd_payments_v ibypmts
889: WHERE ibypmts.org_type = 'OPERATING_UNIT'
890: AND ibypmts.payment_id = ibydocs.payment_id
891: AND ibypmts.completed_pmts_group_id = p_completed_group_id
892: AND ibypmts.org_id = p_current_org_id

Line 935: /iby_fd_payments_v ibypmts, Commented for Bug#9459810 /

931: ps.payment_num
932: FROM ap_payment_schedules_all ps,
933: ap_invoices_all inv,
934: ap_selected_invoices_all si,
935: /*iby_fd_payments_v ibypmts, Commented for Bug#9459810 */
936: iby_fd_docs_payable_v ibydocs
937: WHERE si.checkrun_name = p_checkrun_name
938: AND si.payment_num = ps.payment_num
939: AND si.invoice_id = ps.invoice_id

Line 995: FROM iby_fd_payments_v ifp

991:
992: CURSOR c_prob_iby_payments IS
993: select payment_id, payment_reference_number, payment_instruction_id
994: , null, null, 'IBY_PMT'
995: FROM iby_fd_payments_v ifp
996: WHERE ifp.completed_pmts_group_id = p_completed_pmts_group_id
997: and not exists
998: (select 1
999: from ap_checks_all c

Line 1008: , iby_fd_payments_v ifp

1004: select ifp.payment_id, ifp.payment_reference_number, ifp.payment_instruction_id
1005: , ifd.calling_app_doc_unique_ref2, ifd.calling_app_doc_unique_ref3
1006: , 'IBY_DOC'
1007: from iby_fd_docs_payable_v ifd
1008: , iby_fd_payments_v ifp
1009: where ifd.payment_id = ifp.payment_id (+)
1010: and ifd.completed_pmts_group_id = p_completed_pmts_group_id
1011: and not exists
1012: (select 1

Line 1025: , iby_fd_payments_v ifp

1021: CURSOR c_prob_checks IS
1022: select c.payment_id, ifp.payment_reference_number, ifp.payment_instruction_id
1023: , null, null, 'AP_CHECK'
1024: from ap_checks_all c
1025: , iby_fd_payments_v ifp
1026: where c.completed_pmts_group_id = ifp.completed_pmts_group_id
1027: and c.payment_id = ifp.payment_id
1028: and c.completed_pmts_group_id = p_completed_pmts_group_id
1029: group by c.payment_id, ifp.payment_reference_number, ifp.payment_instruction_id

Line 1038: , iby_fd_payments_v ifp

1034: , ifp.payment_instruction_id, TO_CHAR(ip.invoice_id), TO_CHAR(ip.payment_num)
1035: , 'AP_INV_PAY'
1036: from ap_invoice_payments_all ip
1037: , ap_checks_all c
1038: , iby_fd_payments_v ifp
1039: where ip.check_id = c.check_id
1040: and ifp.payment_id = c.payment_id
1041: and ifp.completed_pmts_group_id = c.completed_pmts_group_id
1042: and c.completed_pmts_group_id = p_completed_pmts_group_id

Line 1101: FROM iby_fd_payments_v pmts,

1097:
1098: /* --Bug 5115310
1099: SELECT calling_app_doc_unique_ref1
1100: INTO l_checkrun_id
1101: FROM iby_fd_payments_v pmts,
1102: iby_fd_docs_payable_v docs
1103: WHERE pmts.payment_id = docs.payment_id
1104: AND pmts.completed_pmts_group_id = p_completed_pmts_group_id
1105: AND pmts.org_type = 'OPERATING_UNIT'

Line 1392: iby_fd_payments_v ibypmts,

1388: NVL(ibypmts.supplier_site_id,-222), --modifed for bug 8405513
1389: ibypmts.relationship_id
1390: FROM ap_invoices_all orig,
1391: ap_supplier_sites_all aps, -- bug 7673570
1392: iby_fd_payments_v ibypmts,
1393: ap_selected_invoices_all new,
1394: iby_fd_docs_payable_v ibydocs,
1395: fnd_currencies fcinv
1396: /* Bug 6950891 . Added TO_CHAR */

Line 1476: iby_fd_payments_v ibypmts,

1472: l_current_org_id
1473: FROM
1474: po_vendors pv,
1475: ap_invoices_all orig,
1476: iby_fd_payments_v ibypmts,
1477: iby_fd_docs_payable_v ibydocs,
1478: ap_selected_invoices_all new, -- Modified for bug 8744658
1479: fnd_currencies fcinv
1480: /* Bug 6950891 Added TO_CHAR */

Line 1582: iby_fd_payments_v ibypmts,

1578: FROM ap_invoices_all orig,
1579: ap_selected_invoices_all new,
1580: ap_supplier_sites_all aps, -- bug 7673570
1581: fnd_currencies fcinv,
1582: iby_fd_payments_v ibypmts,
1583: iby_fd_docs_payable_v ibydocs
1584: /* Bug 6950891 Added TO_CHAR */
1585: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)
1586: AND ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(new.invoice_id)

Line 1624: iby_fd_payments_v ibypmts,

1620: SYSDATE,
1621: l_checkrun_name
1622: FROM ap_invoices_all orig,
1623: ap_selected_invoices_all new,
1624: iby_fd_payments_v ibypmts,
1625: iby_fd_docs_payable_v ibydocs
1626: /* Bug 6950891 Added TO_CHAR */
1627: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)
1628: AND ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(new.invoice_id)

Line 1851: FROM iby_fd_payments_v iby,

1847: NVL(aps.vendor_id, -222), -- modifed for bug 8405513
1848: aps.vendor_site_code,
1849: NVL(iby.supplier_site_id, -222), --modifed for bug 8405513
1850: iby.relationship_id
1851: FROM iby_fd_payments_v iby,
1852: po_vendors pv,
1853: ce_bank_acct_uses_all ce,
1854: ce_bank_accounts ceb,
1855: ap_supplier_sites_all aps -- 7673570

Line 1957: iby_fd_payments_v ibypmts

1953: /* Bug 6950891. Added TO_CHAR */
1954: AND (TO_CHAR(ASI.invoice_id), TO_CHAR(ASI.payment_num)) in
1955: (select calling_app_doc_unique_ref2, calling_app_doc_unique_ref3
1956: FROM iby_fd_docs_payable_v ibydocs,
1957: iby_fd_payments_v ibypmts
1958: WHERE ibydocs.payment_id = ibypmts.payment_id
1959: and ibypmts.org_type = 'OPERATING_UNIT'
1960: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
1961: AND ibypmts.org_id = l_current_org_id);

Line 1987: iby_fd_payments_v ibypmts

1983: AND (TO_CHAR(AATD.invoice_id), TO_CHAR(AATD.payment_num)) in
1984: /* Bug 5383066, calling_app_doc_unique_ref3 should be used for payment_num*/
1985: (select calling_app_doc_unique_ref2, calling_app_doc_unique_ref3
1986: FROM iby_fd_docs_payable_v ibydocs,
1987: iby_fd_payments_v ibypmts
1988: WHERE ibydocs.payment_id = ibypmts.payment_id
1989: and ibypmts.org_type = 'OPERATING_UNIT'
1990: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
1991: AND ibypmts.org_id = l_current_org_id);

Line 2319: iby_fd_payments_v ibypmts,

2315: ac.remit_to_supplier_site,
2316: ac.remit_to_supplier_site_id,
2317: 'U' -- bug 8741899: add
2318: FROM
2319: iby_fd_payments_v ibypmts,
2320: iby_fd_docs_payable_v ibydocs,
2321: ap_selected_invoices_all SI,
2322: fnd_currencies FORE,
2323: ap_payment_schedules_all PS,

Line 2545: iby_fd_payments_v ibypmts,

2541: AND ibydocs.calling_app_doc_unique_ref3 = to_char(si1.payment_num))
2542: WHERE (ps1.invoice_id, ps1.payment_num) in
2543: (SELECT SI3.invoice_id, SI3.payment_num
2544: FROM ap_selected_invoices_all SI3,
2545: iby_fd_payments_v ibypmts,
2546: iby_fd_docs_payable_v ibydocs,
2547: ap_invoices_all AI
2548: WHERE SI3.checkrun_name = l_checkrun_name
2549: AND ibydocs.calling_app_doc_unique_ref1 = to_char(si3.checkrun_id)

Line 2580: iby_fd_payments_v ibypmts

2576: nvl(inv1.amount_paid,0) + sum(ibydocs.payment_amount),
2577: nvl(inv1.discount_amount_taken,0) + nvl(sum(ibydocs.payment_curr_discount_taken),0),
2578: AP_INVOICES_UTILITY_PKG.get_payment_status( inv1.invoice_id )
2579: FROM iby_fd_docs_payable_v ibydocs,
2580: iby_fd_payments_v ibypmts
2581: WHERE ibypmts.org_type = 'OPERATING_UNIT'
2582: AND ibypmts.payment_id = ibydocs.payment_id
2583: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
2584: AND ibypmts.org_id = l_current_org_id

Line 2594: iby_fd_payments_v ibypmts

2590: )
2591: WHERE invoice_id IN
2592: (SELECT ibydocs.calling_app_doc_unique_ref2
2593: FROM iby_fd_docs_payable_v ibydocs,
2594: iby_fd_payments_v ibypmts
2595: WHERE ibypmts.payment_id = ibydocs.payment_id
2596: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
2597: and ibypmts.org_type = 'OPERATING_UNIT'
2598: AND ibypmts.org_id = l_current_org_id)

Line 2716: iby_fd_payments_v ibypmts

2712: and (TO_CHAR(invoice_id), TO_CHAR(payment_num)) in
2713: (select ibydocs.calling_app_doc_unique_ref2,
2714: ibydocs.calling_app_doc_unique_ref3
2715: from iby_fd_docs_payable_v ibydocs,
2716: iby_fd_payments_v ibypmts
2717: where ibypmts.payment_id = ibydocs.payment_id
2718: and ibypmts.org_type = 'OPERATING_UNIT'
2719: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
2720: AND ibypmts.org_id = l_current_org_id);

Line 2740: FROM iby_fd_payments_v

2736:
2737:
2738: SELECT COUNT(*)
2739: INTO l_iby_check_count
2740: FROM iby_fd_payments_v
2741: WHERE completed_pmts_group_id = p_completed_pmts_group_id;
2742:
2743: SELECT COUNT(*)
2744: INTO l_iby_docs_count