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_DOCUMENT_TOTALS_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 238: FROM po_lines_archive_all pol

234: nvl2(l_mau
235: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
236: , round((pol.quantity*pol.unit_price),l_precision)) )) -- Bug# 5378134
237: INTO l_return_val
238: FROM po_lines_archive_all pol
239: WHERE pol.po_header_id = p_doc_level_id
240: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
241: OR (p_doc_revision_num IS NOT NULL
242: AND POL.revision_num =

Line 244: FROM po_lines_archive_all pol2

240: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
241: OR (p_doc_revision_num IS NOT NULL
242: AND POL.revision_num =
243: (SELECT max(POL2.revision_num)
244: FROM po_lines_archive_all pol2
245: WHERE pol2.po_line_id = pol.po_line_id
246: AND pol2.revision_num <= p_doc_revision_num)
247: )
248: )

Line 288: FROM po_lines_archive_all pol

284: nvl2(l_mau
285: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
286: , round((pol.quantity*pol.unit_price),l_precision)) ) -- Bug# 5378134
287: INTO l_return_val
288: FROM po_lines_archive_all pol
289: WHERE pol.po_line_id = p_doc_level_id
290: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
291: OR (p_doc_revision_num IS NOT NULL
292: AND POL.revision_num =

Line 294: FROM po_lines_archive_all pol2

290: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
291: OR (p_doc_revision_num IS NOT NULL
292: AND POL.revision_num =
293: (SELECT max(POL2.revision_num)
294: FROM po_lines_archive_all pol2
295: WHERE pol2.po_line_id = pol.po_line_id
296: AND pol2.revision_num <= p_doc_revision_num)
297: )
298: )