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 1007: l_from_clause:=l_from_clause||',po_vendor_sites povs';

1003: if vendor_site_id is not null then
1004: l_where_clause:=l_where_clause||' and per_asg.vendor_site_id='||vendor_site_id;
1005: l_asg:=TRUE;
1006: elsif vendor_site_code is not null then
1007: l_from_clause:=l_from_clause||',po_vendor_sites povs';
1008: l_where_clause:=l_where_clause||' and per_asg.vendor_site_id=povs.vendor_site_id'
1009: ||' and upper(povs.vendor_site_code) like ('''||upper(replace(vendor_site_code,g_quote,g_quote||g_quote))||''')';
1010: l_asg:=TRUE;
1011: end if;

Line 2474: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%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
2476: ,po_header_num in po_headers_all.segment1%TYPE default null
2477: ,po_header_id in po_headers_all.po_header_id%TYPE default null
2478: ,po_line_num in po_lines_all.line_num%TYPE default null

Line 2475: ,vendor_site_id in po_vendor_sites_all.vendor_site_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
2476: ,po_header_num in po_headers_all.segment1%TYPE default null
2477: ,po_header_id in po_headers_all.po_header_id%TYPE default null
2478: ,po_line_num in po_lines_all.line_num%TYPE default null
2479: ,po_line_id in po_lines_all.po_line_id%TYPE default null