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_INVOICES

Line 418: l_invoice_num Ap_Invoices.invoice_num%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;
422: l_checkrun_name Fv_Tpp_Check_Details.checkrun_name%TYPE;

Line 419: l_invoice_amount Ap_Invoices.invoice_amount%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;
422: l_checkrun_name Fv_Tpp_Check_Details.checkrun_name%TYPE;
423: l_check_num_fvtpp Fv_Tpp_Check_Details.check_number%TYPE;

Line 420: l_discount_amount Ap_Invoices.discount_amount_taken%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;
422: l_checkrun_name Fv_Tpp_Check_Details.checkrun_name%TYPE;
423: l_check_num_fvtpp Fv_Tpp_Check_Details.check_number%TYPE;
424: l_bank_account_id Ap_Invoice_Selection_Criteria.bank_account_id%TYPE;

Line 425: l_invoice_id Ap_Invoices.invoice_id%TYPE;

421: l_assignment_id Fv_Tpp_Assignments.assignment_id%TYPE;
422: l_checkrun_name Fv_Tpp_Check_Details.checkrun_name%TYPE;
423: l_check_num_fvtpp Fv_Tpp_Check_Details.check_number%TYPE;
424: l_bank_account_id Ap_Invoice_Selection_Criteria.bank_account_id%TYPE;
425: l_invoice_id Ap_Invoices.invoice_id%TYPE;
426: l_vendor_name Po_Vendors.vendor_name%TYPE;
427: l_site_code Po_Vendor_Sites.vendor_site_code%TYPE;
428: l_exists VARCHAR2(1);
429: i NUMBER := 0;

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