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 FV_TPP_ASSIGNMENTS

Line 15: g_from_supp_id Fv_Tpp_Assignments.original_supplier_id%TYPE;

11: g_sob_id gl_ledgers.ledger_id%TYPE;
12: g_sob_name gl_ledgers.name%TYPE;
13: g_pay_date_from DATE;
14: g_pay_date_to DATE;
15: g_from_supp_id Fv_Tpp_Assignments.original_supplier_id%TYPE;
16: g_from_site_id Fv_Tpp_Assignments.original_supplier_site_id%TYPE;
17: g_to_supp_id Fv_Tpp_Assignments.third_party_agent_id%TYPE;
18: g_to_site_id Fv_Tpp_Assignments.third_party_site_id%TYPE;
19: g_from_supp_name Po_Vendors.vendor_name%TYPE;

Line 16: g_from_site_id Fv_Tpp_Assignments.original_supplier_site_id%TYPE;

12: g_sob_name gl_ledgers.name%TYPE;
13: g_pay_date_from DATE;
14: g_pay_date_to DATE;
15: g_from_supp_id Fv_Tpp_Assignments.original_supplier_id%TYPE;
16: g_from_site_id Fv_Tpp_Assignments.original_supplier_site_id%TYPE;
17: g_to_supp_id Fv_Tpp_Assignments.third_party_agent_id%TYPE;
18: g_to_site_id Fv_Tpp_Assignments.third_party_site_id%TYPE;
19: g_from_supp_name Po_Vendors.vendor_name%TYPE;
20: g_to_supp_name Po_Vendors.vendor_name%TYPE;

Line 17: g_to_supp_id Fv_Tpp_Assignments.third_party_agent_id%TYPE;

13: g_pay_date_from DATE;
14: g_pay_date_to DATE;
15: g_from_supp_id Fv_Tpp_Assignments.original_supplier_id%TYPE;
16: g_from_site_id Fv_Tpp_Assignments.original_supplier_site_id%TYPE;
17: g_to_supp_id Fv_Tpp_Assignments.third_party_agent_id%TYPE;
18: g_to_site_id Fv_Tpp_Assignments.third_party_site_id%TYPE;
19: g_from_supp_name Po_Vendors.vendor_name%TYPE;
20: g_to_supp_name Po_Vendors.vendor_name%TYPE;
21: g_from_site_code Po_Vendor_Sites.vendor_site_code%TYPE;

Line 18: g_to_site_id Fv_Tpp_Assignments.third_party_site_id%TYPE;

14: g_pay_date_to DATE;
15: g_from_supp_id Fv_Tpp_Assignments.original_supplier_id%TYPE;
16: g_from_site_id Fv_Tpp_Assignments.original_supplier_site_id%TYPE;
17: g_to_supp_id Fv_Tpp_Assignments.third_party_agent_id%TYPE;
18: g_to_site_id Fv_Tpp_Assignments.third_party_site_id%TYPE;
19: g_from_supp_name Po_Vendors.vendor_name%TYPE;
20: g_to_supp_name Po_Vendors.vendor_name%TYPE;
21: g_from_site_code Po_Vendor_Sites.vendor_site_code%TYPE;
22: g_to_site_code Po_Vendor_Sites.vendor_site_code%TYPE;

Line 421: l_assignment_id Fv_Tpp_Assignments.assignment_id%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;
425: l_invoice_id Ap_Invoices.invoice_id%TYPE;

Line 514: FROM fv_tpp_check_details fvcd, fv_tpp_assignments_all tpp, ap_invoice_selection_criteria apisc

510:
511: l_row_select := '
512: SELECT fvcd.assignment_id, tpp.original_supplier_id, tpp.original_supplier_site_id,
513: tpp.third_party_agent_id, tpp.third_party_site_id, fvcd.checkrun_name, fvcd.check_number
514: FROM fv_tpp_check_details fvcd, fv_tpp_assignments_all tpp, ap_invoice_selection_criteria apisc
515: WHERE '|| l_where_clause ||'
516: fvcd.checkrun_name = apisc.checkrun_name
517: AND apisc.status = '||''''|| 'CONFIRMED' ||''''||'
518: AND fvcd.set_of_books_id = '|| g_sob_id ||'

Line 694: fv_tpp_assignments_all fv

690: BEGIN
691: SELECT pv.vendor_name, ps.vendor_site_code
692: INTO l_vendor_name, l_site_code
693: FROM po_vendors pv, po_vendor_sites ps,
694: fv_tpp_assignments_all fv
695: WHERE fv.assignment_id = l_assignment_id
696: AND fv.set_of_books_id = g_sob_id
697: AND fv.org_id = g_org_id
698: AND pv.vendor_id = DECODE(i, 1, fv.original_supplier_id,