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.PO_XML_UTILS_GRP dependencies on PO_HEADERS_ALL

Line 107: from po_headers_all pha, po_releases_all pra

103: begin
104: if (upper(p_po_type) = 'RELEASE') then
105: /*
106: select pha.segment1 into p_blanket_po_num
107: from po_headers_all pha, po_releases_all pra
108: where pra.po_header_id = pha.po_header_id and
109: pra.po_release_id = p_release_id;
110: */
111: select segment1 into p_blanket_po_num

Line 112: from po_headers_all

108: where pra.po_header_id = pha.po_header_id and
109: pra.po_release_id = p_release_id;
110: */
111: select segment1 into p_blanket_po_num
112: from po_headers_all
113: where po_header_id = p_release_id;
114: end if;
115:
116: exception

Line 264: from po_releases_all pra, po_headers_all pha

260:
261: if (upper(p_po_type) = 'RELEASE') then
262: select pha.segment1, pha.org_id
263: into l_po_number, l_org_id
264: from po_releases_all pra, po_headers_all pha
265: where pra.po_release_id = p_po_header_id
266: and pra.po_header_id = pha.po_header_id;
267:
268:

Line 272: from po_headers_all pha

268:
269: elsif (upper(p_po_type) = 'STANDARD') then
270: select pha.segment1, pha.org_id
271: into l_po_number, l_org_id
272: from po_headers_all pha
273: where pha.po_header_id = p_po_header_id;
274: /*
275: else ideally we should raise an exception.
276: */

Line 350: from po_headers_all glblH, po_lines_all glblSPO

346: begin
347:
348: select glblH.segment1
349: into x_GLOBALCONTRACT
350: from po_headers_all glblH, po_lines_all glblSPO
351: where glblSPO.po_line_id = p_po_line_id and
352: glblSPO.from_header_id = glblH.po_header_id and
353: glblH.global_agreement_flag = 'Y';
354: