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 997: l_from_clause:=l_from_clause||',po_vendors pov';

993: if vendor_id is not null then
994: l_where_clause:=l_where_clause||' and per_asg.vendor_id='||vendor_id;
995: l_asg:=TRUE;
996: elsif vendor_name is not null then
997: l_from_clause:=l_from_clause||',po_vendors pov';
998: l_where_clause:=l_where_clause||' and per_asg.vendor_id=pov.vendor_id'
999: ||' and upper(pov.vendor_name) like ('''||upper(replace(vendor_name,g_quote,g_quote||g_quote))||''')';
1000: l_asg:=TRUE;
1001: end if;

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

2467: --CWK
2468: ,npw_number in per_all_people_f.npw_number%type default null
2469: ,project_title in per_all_assignments_f.project_title%type default null
2470: ,vendor_id in per_all_assignments_f.vendor_id%type default null
2471: ,vendor_name in po_vendors.vendor_name%type default null
2472: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
2473: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2474: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
2475: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null