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.FV_THIRD_PARTY_REMIT_PKG dependencies on AP_CHECKS

Line 414: l_check_id Ap_Checks.check_id%TYPE;

410: l_original_supplier_id Po_Vendors.vendor_id%TYPE;
411: l_original_site_id Po_Vendor_Sites.vendor_site_id%TYPE;
412: l_third_party_agent_id Po_Vendors.vendor_id%TYPE;
413: l_third_party_site_id Po_Vendor_Sites.vendor_site_id%TYPE;
414: l_check_id Ap_Checks.check_id%TYPE;
415: l_check_number Ap_Checks.check_number%TYPE;
416: l_check_date Ap_Checks.check_date%TYPE;
417: l_check_amount Ap_Checks.amount%TYPE;
418: l_invoice_num Ap_Invoices.invoice_num%TYPE;

Line 415: l_check_number Ap_Checks.check_number%TYPE;

411: l_original_site_id Po_Vendor_Sites.vendor_site_id%TYPE;
412: l_third_party_agent_id Po_Vendors.vendor_id%TYPE;
413: l_third_party_site_id Po_Vendor_Sites.vendor_site_id%TYPE;
414: l_check_id Ap_Checks.check_id%TYPE;
415: l_check_number Ap_Checks.check_number%TYPE;
416: l_check_date Ap_Checks.check_date%TYPE;
417: l_check_amount Ap_Checks.amount%TYPE;
418: l_invoice_num Ap_Invoices.invoice_num%TYPE;
419: l_invoice_amount Ap_Invoices.invoice_amount%TYPE;

Line 416: l_check_date Ap_Checks.check_date%TYPE;

412: l_third_party_agent_id Po_Vendors.vendor_id%TYPE;
413: l_third_party_site_id Po_Vendor_Sites.vendor_site_id%TYPE;
414: l_check_id Ap_Checks.check_id%TYPE;
415: l_check_number Ap_Checks.check_number%TYPE;
416: l_check_date Ap_Checks.check_date%TYPE;
417: l_check_amount Ap_Checks.amount%TYPE;
418: l_invoice_num Ap_Invoices.invoice_num%TYPE;
419: l_invoice_amount Ap_Invoices.invoice_amount%TYPE;
420: l_discount_amount Ap_Invoices.discount_amount_taken%TYPE;

Line 417: l_check_amount Ap_Checks.amount%TYPE;

413: l_third_party_site_id Po_Vendor_Sites.vendor_site_id%TYPE;
414: l_check_id Ap_Checks.check_id%TYPE;
415: l_check_number Ap_Checks.check_number%TYPE;
416: l_check_date Ap_Checks.check_date%TYPE;
417: l_check_amount Ap_Checks.amount%TYPE;
418: l_invoice_num Ap_Invoices.invoice_num%TYPE;
419: l_invoice_amount Ap_Invoices.invoice_amount%TYPE;
420: l_discount_amount Ap_Invoices.discount_amount_taken%TYPE;
421: l_assignment_id Fv_Tpp_Assignments.assignment_id%TYPE;

Line 437: FROM ap_checks apc, ap_invoice_payments apip, ap_invoices api

433:
434: CURSOR l_checks_invoices_cur IS
435: SELECT apc.check_number, apc.check_date, apc.amount,
436: invoice_num, invoice_amount, discount_amount_taken
437: FROM ap_checks apc, ap_invoice_payments apip, ap_invoices api
438: WHERE apc.bank_account_id = l_bank_account_id
439: AND apc.checkrun_name = l_checkrun_name
440: AND apc.check_number = l_check_num_fvtpp
441: AND apc.vendor_id = l_third_party_agent_id