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.

[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on IBY_FD_DOCS_PAYABLE_V

Line 563: iby_fd_docs_payable_v ibydocs

559: , vendor_id
560: , payment_num
561: FROM ap_SELECTed_invoices_all ASI,
562: ap_system_parameters_all asp,
563: iby_fd_docs_payable_v ibydocs
564: WHERE checkrun_name = l_checkrun_name
565: AND original_invoice_id IS NULL
566: /* Bug 6950891. Added TO_CHAR */
567: AND ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(ASI.checkrun_id)

Line 592: from iby_fd_docs_payable_v

588:
589:
590: select calling_app_doc_unique_ref1
591: into l_checkrun_id
592: from iby_fd_docs_payable_v
593: where rejected_docs_group_id = p_rejected_docs_group_id
594: and rownum=1;
595:
596:

Line 646: from iby_fd_docs_payable_v

642: /* Bug 6950891. Added TO_CHAR */
643: and (TO_CHAR(invoice_id), TO_CHAR(payment_num)) in
644: (select calling_app_doc_unique_ref2,
645: calling_app_doc_unique_ref3
646: from iby_fd_docs_payable_v
647: where rejected_docs_group_id = p_rejected_docs_group_id);
648:
649: update ap_payment_schedules_all
650: set checkrun_id = null

Line 656: from iby_fd_docs_payable_v

652: /* Bug 6950891. Added TO_CHAR */
653: and (TO_CHAR(invoice_id), TO_CHAR(payment_num)) in
654: (select calling_app_doc_unique_ref2,
655: calling_app_doc_unique_ref3
656: from iby_fd_docs_payable_v
657: where rejected_docs_group_id = p_rejected_docs_group_id);
658:
659:
660: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 739: iby_fd_docs_payable_v docs

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

Line 748: iby_fd_docs_payable_v docs

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

Line 790: FROM iby_fd_docs_payable_v ibydocs,

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

Line 837: iby_fd_docs_payable_v ibydocs

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

Line 905: iby_fd_docs_payable_v docs

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

Line 1207: iby_fd_docs_payable_v ibydocs,

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

Line 1307: iby_fd_docs_payable_v ibydocs,

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

Line 1411: iby_fd_docs_payable_v ibydocs

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

Line 1452: iby_fd_docs_payable_v ibydocs

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

Line 1766: FROM iby_fd_docs_payable_v ibydocs,

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

Line 1795: FROM iby_fd_docs_payable_v ibydocs,

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

Line 1832: FROM iby_fd_docs_payable_v ibydocs

1828: AND org_id = l_current_org_id
1829: and checkrun_id = l_checkrun_id
1830: and (invoice_id, payment_num) in
1831: (select calling_app_doc_unique_ref2, calling_app_doc_unique_ref2
1832: FROM iby_fd_docs_payable_v ibydocs
1833: where calling_app_doc_unique_ref1 = l_checkrun_id
1834: and completed_pmts_group_id = p_completed_pmts_group_id
1835: and org_id = l_current_org_id);
1836: */

Line 2127: iby_fd_docs_payable_v ibydocs,

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

Line 2321: iby_fd_docs_payable_v ibydocs

2317: decode(SI1.amount_remaining - ibydocs.payment_amount - nvl(ibydocs.payment_curr_discount_taken,0), 0,
2318: 'Y', 'P'),
2319: null --set checkrun_id to null
2320: FROM ap_selected_invoices_all SI1,
2321: iby_fd_docs_payable_v ibydocs
2322: WHERE checkrun_name = l_checkrun_name
2323: AND SI1.payment_num = ps1.payment_num
2324: AND SI1.invoice_id = ps1.invoice_id
2325: AND ibydocs.calling_app_doc_unique_ref1 = to_char(si1.checkrun_id)

Line 2332: iby_fd_docs_payable_v ibydocs,

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

Line 2365: FROM iby_fd_docs_payable_v ibydocs,

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

Line 2379: FROM iby_fd_docs_payable_v ibydocs,

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

Line 2472: from iby_fd_docs_payable_v ibydocs,

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

Line 2501: FROM iby_fd_docs_payable_v

2497: WHERE completed_pmts_group_id = p_completed_pmts_group_id;
2498:
2499: SELECT COUNT(*)
2500: INTO l_iby_docs_count
2501: FROM iby_fd_docs_payable_v
2502: WHERE completed_pmts_group_id = p_completed_pmts_group_id;
2503:
2504: l_debug_info := '******AP-IBY COUNTS****************';
2505: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN