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_APPROVE_SV dependencies on PO_ACTION_HISTORY

Line 161: po_action_history pah

157: pah.approval_path_id
158: INTO x_approval_path,
159: x_approval_path_id
160: FROM per_position_structures pps,
161: po_action_history pah
162: WHERE pah.approval_path_id = pps.position_structure_id
163: AND pah.object_id = x_object_id
164: AND pah.object_type_code = x_document_type_code
165: AND pah.object_sub_type_code = x_document_subtype

Line 168: FROM po_action_history PAH2

164: AND pah.object_type_code = x_document_type_code
165: AND pah.object_sub_type_code = x_document_subtype
166: AND pah.sequence_num =
167: (SELECT max(sequence_num)
168: FROM po_action_history PAH2
169: WHERE PAH2.object_id = x_object_id
170: AND PAH2.object_type_code = x_document_type_code
171: AND PAH2.object_sub_type_code = x_document_subtype
172: AND PAH2.action_code is not null);