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 PO_VENDORS

Line 19: g_from_supp_name Po_Vendors.vendor_name%TYPE;

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;
23: g_sort_by VARCHAR2(1);

Line 20: g_to_supp_name Po_Vendors.vendor_name%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;
23: g_sort_by VARCHAR2(1);
24: g_checkrun_name VARCHAR2(50);

Line 338: l_vendor_name Po_Vendors.vendor_name%TYPE;

334: -- corresponding to a vendor_id
335: -- -------------------------------------------------------------
336: FUNCTION VENDOR_NAME(p_vendor_id NUMBER) RETURN VARCHAR2 IS
337: l_module_name VARCHAR2(200);
338: l_vendor_name Po_Vendors.vendor_name%TYPE;
339: BEGIN
340:
341: l_module_name := g_module_name || 'VENDOR_NAME';
342:

Line 345: FROM po_vendors

341: l_module_name := g_module_name || 'VENDOR_NAME';
342:
343: SELECT vendor_name
344: INTO l_vendor_name
345: FROM po_vendors
346: WHERE vendor_id = p_vendor_id;
347:
348: RETURN(l_vendor_name);
349: EXCEPTION

Line 406: l_original_supplier Po_Vendors.vendor_name%TYPE;

402: l_row_select VARCHAR2(3000);
403: l_row_cursor INTEGER;
404: l_row_fetch INTEGER;
405: l_exec_ret INTEGER;
406: l_original_supplier Po_Vendors.vendor_name%TYPE;
407: l_original_site Po_Vendor_Sites.vendor_site_code%TYPE;
408: l_third_party_agent Po_Vendors.vendor_name%TYPE;
409: l_third_party_site Po_Vendor_Sites.vendor_site_code%TYPE;
410: l_original_supplier_id Po_Vendors.vendor_id%TYPE;

Line 408: l_third_party_agent Po_Vendors.vendor_name%TYPE;

404: l_row_fetch INTEGER;
405: l_exec_ret INTEGER;
406: l_original_supplier Po_Vendors.vendor_name%TYPE;
407: l_original_site Po_Vendor_Sites.vendor_site_code%TYPE;
408: l_third_party_agent Po_Vendors.vendor_name%TYPE;
409: l_third_party_site Po_Vendor_Sites.vendor_site_code%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;

Line 410: l_original_supplier_id Po_Vendors.vendor_id%TYPE;

406: l_original_supplier Po_Vendors.vendor_name%TYPE;
407: l_original_site Po_Vendor_Sites.vendor_site_code%TYPE;
408: l_third_party_agent Po_Vendors.vendor_name%TYPE;
409: l_third_party_site Po_Vendor_Sites.vendor_site_code%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;

Line 412: l_third_party_agent_id Po_Vendors.vendor_id%TYPE;

408: l_third_party_agent Po_Vendors.vendor_name%TYPE;
409: l_third_party_site Po_Vendor_Sites.vendor_site_code%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;

Line 426: l_vendor_name Po_Vendors.vendor_name%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;
430: l NUMBER;

Line 693: FROM po_vendors pv, po_vendor_sites ps,

689: LOOP
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