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_LINES_ALL

Line 36: ,po_line_num po_lines_all.line_num%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
38: --
39: ,first_name per_all_people_f.first_name%type default null
40: ,full_name per_all_people_f.full_name%type default null

Line 37: ,po_line_id po_lines_all.po_line_id%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
38: --
39: ,first_name per_all_people_f.first_name%type default null
40: ,full_name per_all_people_f.full_name%type default null
41: ,title per_all_people_f.title%type

Line 386: from po_lines_all

382: where po_header_id = p_po_header_id;
383: --
384: cursor csr_po_line(p_po_line_id in number) is
385: select line_num
386: from po_lines_all
387: where po_line_id = p_po_line_id;
388: --Bug 4060365. Changed the size of the variable l_where from 400 to 2000
389: function build_varchar2_where
390: (p_parent_column varchar2

Line 1027: l_from_clause:=l_from_clause||',po_lines_all pol';

1023: if po_line_id is not null then
1024: l_where_clause:=l_where_clause||' and per_asg.po_line_id='||po_line_id;
1025: l_asg:=TRUE;
1026: elsif po_line_num is not null then
1027: l_from_clause:=l_from_clause||',po_lines_all pol';
1028: l_where_clause:=l_where_clause||' and per_asg.po_line_id=pol.po_line_id'
1029: ||' and upper(pol.line_num) like ('''||upper(replace(po_line_num,g_quote,g_quote||g_quote))||''')';
1030: l_asg:=TRUE;
1031: end if;

Line 2478: ,po_line_num in po_lines_all.line_num%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
2480: --
2481: ,first_name in per_all_people_f.first_name%type default null
2482: ,full_name in per_all_people_f.full_name%type default null

Line 2479: ,po_line_id in po_lines_all.po_line_id%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
2480: --
2481: ,first_name in per_all_people_f.first_name%type default null
2482: ,full_name in per_all_people_f.full_name%type default null
2483: ,title in per_all_people_f.title%type