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_DOCS_PAYABLE_V

Line 620: from iby_fd_docs_payable_v

616:
617: /* A single Payment Instruction can carry payments from multiple PPRs, hence a cursor to hold Check Run IDs Bug 14091572*/
618: CURSOR c_checkrun_id IS
619: select distinct calling_app_doc_unique_ref1
620: from iby_fd_docs_payable_v
621: where rejected_docs_group_id = p_rejected_docs_group_id;
622:
623: rec_checkrun_id c_checkrun_id%ROWTYPE;
624: /*Bug 5020577*/

Line 632: iby_fd_docs_payable_v ibydocs

628: vendor_id,
629: payment_num
630: FROM ap_SELECTed_invoices_all ASI,
631: ap_system_parameters_all asp,
632: iby_fd_docs_payable_v ibydocs
633: WHERE checkrun_name = l_checkrun_name
634: AND original_invoice_id IS NULL
635: /* Bug 6950891. Added TO_CHAR */
636: /* Bug 12730662. Removed TO_CHAR */

Line 721: from iby_fd_docs_payable_v

717: /* Bug 12679356. Removed to_char */
718: and (invoice_id, payment_num) in
719: (select calling_app_doc_unique_ref2,
720: calling_app_doc_unique_ref3
721: from iby_fd_docs_payable_v
722: where rejected_docs_group_id = p_rejected_docs_group_id);
723:
724: update ap_payment_schedules_all
725: set checkrun_id = null

Line 732: from iby_fd_docs_payable_v

728: /* Bug 12679356. Removed to_char */
729: and (invoice_id, payment_num) in
730: (select calling_app_doc_unique_ref2,
731: calling_app_doc_unique_ref3
732: from iby_fd_docs_payable_v
733: where rejected_docs_group_id = p_rejected_docs_group_id);
734:
735:
736: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 836: iby_fd_docs_payable_v docs

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';
840:

Line 845: iby_fd_docs_payable_v docs

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'
849: AND docs.calling_app_doc_unique_ref1 = c_checkrun_id;

Line 887: FROM iby_fd_docs_payable_v ibydocs,

883: nvl(sum(ibydocs.payment_curr_discount_taken),0) iby_discount_amount_taken,
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

Line 936: iby_fd_docs_payable_v ibydocs

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
940: AND ibydocs.calling_app_doc_unique_ref1 = to_char(si.checkrun_id)

Line 1007: from iby_fd_docs_payable_v ifd

1003: CURSOR c_prob_iby_docs IS
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

Line 1102: iby_fd_docs_payable_v docs

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'
1106: AND rownum=1;

Line 1394: iby_fd_docs_payable_v ibydocs,

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 */
1397: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)
1398: AND ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(new.invoice_id)

Line 1477: iby_fd_docs_payable_v ibydocs,

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 */
1481: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)

Line 1583: iby_fd_docs_payable_v ibydocs

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)
1587: AND ibydocs.calling_app_doc_unique_ref3 = TO_CHAR(new.payment_num)

Line 1625: iby_fd_docs_payable_v ibydocs

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)
1629: and ibypmts.org_type = 'OPERATING_UNIT'

Line 1956: FROM iby_fd_docs_payable_v ibydocs,

1952: WHERE ASI.checkrun_id = l_checkrun_id
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

Line 1986: FROM iby_fd_docs_payable_v ibydocs,

1982: /* Bug 6950891. Added TO_CHAR */
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

Line 2025: FROM iby_fd_docs_payable_v ibydocs

2021: AND org_id = l_current_org_id
2022: and checkrun_id = l_checkrun_id
2023: and (invoice_id, payment_num) in
2024: (select calling_app_doc_unique_ref2, calling_app_doc_unique_ref2
2025: FROM iby_fd_docs_payable_v ibydocs
2026: where calling_app_doc_unique_ref1 = l_checkrun_id
2027: and completed_pmts_group_id = p_completed_pmts_group_id
2028: and org_id = l_current_org_id);
2029: */

Line 2320: iby_fd_docs_payable_v ibydocs,

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,
2324: ap_invoices_all AI,

Line 2535: iby_fd_docs_payable_v ibydocs

2531: decode(SI1.amount_remaining - ibydocs.payment_amount - nvl(ibydocs.payment_curr_discount_taken,0), 0,
2532: 'Y', 'P'),
2533: null --set checkrun_id to null
2534: FROM ap_selected_invoices_all SI1,
2535: iby_fd_docs_payable_v ibydocs
2536: WHERE checkrun_name = l_checkrun_name
2537: AND SI1.payment_num = ps1.payment_num
2538: AND SI1.invoice_id = ps1.invoice_id
2539: AND ibydocs.calling_app_doc_unique_ref1 = to_char(si1.checkrun_id)

Line 2546: iby_fd_docs_payable_v ibydocs,

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)
2550: AND ibydocs.calling_app_doc_unique_ref2 = to_char(si3.invoice_id)

Line 2579: FROM iby_fd_docs_payable_v ibydocs,

2575: l_last_updated_by,
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

Line 2593: FROM iby_fd_docs_payable_v ibydocs,

2589: and checkrun_name = l_checkrun_name)
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'

Line 2715: from iby_fd_docs_payable_v ibydocs,

2711: /* Bug 6950891. Added TO_CHAR */
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

Line 2745: FROM iby_fd_docs_payable_v

2741: WHERE completed_pmts_group_id = p_completed_pmts_group_id;
2742:
2743: SELECT COUNT(*)
2744: INTO l_iby_docs_count
2745: FROM iby_fd_docs_payable_v
2746: WHERE completed_pmts_group_id = p_completed_pmts_group_id;
2747:
2748: l_debug_info := '******AP-IBY COUNTS****************';
2749: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);