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_COMPLEX_WORK_PVT dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 736: FROM po_line_locations_archive_all polla

732: d_progress := 30;
733:
734: SELECT polla.amount
735: INTO l_advance_amount
736: FROM po_line_locations_archive_all polla
737: WHERE polla.po_line_id = p_po_line_id
738: AND polla.revision_num =
739: (
740: SELECT MAX(polla2.revision_num)

Line 741: FROM po_line_locations_archive_all polla2

737: WHERE polla.po_line_id = p_po_line_id
738: AND polla.revision_num =
739: (
740: SELECT MAX(polla2.revision_num)
741: FROM po_line_locations_archive_all polla2
742: WHERE polla2.line_location_id = polla.line_location_id
743: AND polla2.revision_num <= p_doc_revision_num
744: )
745: AND polla.payment_type = 'ADVANCE';