APPS.PER_QH_FIND_QUERY dependencies on PO_VENDOR_SITES

Line 32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%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
34: ,po_header_num po_headers_all.segment1%TYPE default null
35: ,po_header_id po_headers_all.po_header_id%TYPE default null
36: ,po_line_num po_lines_all.line_num%TYPE default null

Line 33: ,vendor_site_id po_vendor_sites_all.vendor_site_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
34: ,po_header_num po_headers_all.segment1%TYPE default null
35: ,po_header_id po_headers_all.po_header_id%TYPE default null
36: ,po_line_num po_lines_all.line_num%TYPE default null
37: ,po_line_id po_lines_all.po_line_id%TYPE default null

Line 376: from po_vendor_sites

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
376: from po_vendor_sites
377: where vendor_site_id=p_vendor_site_id;
378: --
379: cursor csr_po_header(p_po_header_id in number) is
380: select segment1

Line 991: l_from_clause:=l_from_clause||',po_vendor_sites povs';

987: if vendor_site_id is not null then
988: l_where_clause:=l_where_clause||' and per_asg.vendor_site_id='||vendor_site_id;
989: l_asg:=TRUE;
990: elsif vendor_site_code is not null then
991: l_from_clause:=l_from_clause||',po_vendor_sites povs';
992: l_where_clause:=l_where_clause||' and per_asg.vendor_site_id=povs.vendor_site_id'
993: ||' and upper(povs.vendor_site_code) like ('''||upper(replace(vendor_site_code,g_quote,g_quote||g_quote))||''')';
994: l_asg:=TRUE;
995: end if;

Line 2458: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%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
2460: ,po_header_num in po_headers_all.segment1%TYPE default null
2461: ,po_header_id in po_headers_all.po_header_id%TYPE default null
2462: ,po_line_num in po_lines_all.line_num%TYPE default null

Line 2459: ,vendor_site_id in po_vendor_sites_all.vendor_site_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
2460: ,po_header_num in po_headers_all.segment1%TYPE default null
2461: ,po_header_id in po_headers_all.po_header_id%TYPE default null
2462: ,po_line_num in po_lines_all.line_num%TYPE default null
2463: ,po_line_id in po_lines_all.po_line_id%TYPE default null