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.PER_QH_FIND_QUERY dependencies on PO_VENDORS

Line 29: ,vendor_name po_vendors.vendor_name%type default null

25: --CWK
26: ,npw_number per_all_people_f.npw_number%type default null
27: ,project_title per_all_assignments_f.project_title%type default null
28: ,vendor_id per_all_assignments_f.vendor_id%type default null
29: ,vendor_name po_vendors.vendor_name%type default null
30: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type default null
31: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE default null
33: ,vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE default null

Line 371: from po_vendors pov

367: scl_rec hr_soft_coding_keyflex%rowtype;
368: --
369: cursor csr_vendor(p_vendor_id in number) is
370: select vendor_name
371: from po_vendors pov
372: where pov.vendor_id = p_vendor_id;
373: --
374: cursor csr_vendor_site(p_vendor_site_id in number) is
375: select vendor_site_code

Line 981: l_from_clause:=l_from_clause||',po_vendors pov';

977: if vendor_id is not null then
978: l_where_clause:=l_where_clause||' and per_asg.vendor_id='||vendor_id;
979: l_asg:=TRUE;
980: elsif vendor_name is not null then
981: l_from_clause:=l_from_clause||',po_vendors pov';
982: l_where_clause:=l_where_clause||' and per_asg.vendor_id=pov.vendor_id'
983: ||' and upper(pov.vendor_name) like ('''||upper(replace(vendor_name,g_quote,g_quote||g_quote))||''')';
984: l_asg:=TRUE;
985: end if;

Line 2455: ,vendor_name in po_vendors.vendor_name%type default null

2451: --CWK
2452: ,npw_number in per_all_people_f.npw_number%type default null
2453: ,project_title in per_all_assignments_f.project_title%type default null
2454: ,vendor_id in per_all_assignments_f.vendor_id%type default null
2455: ,vendor_name in po_vendors.vendor_name%type default null
2456: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
2457: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2458: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
2459: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null