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

Line 370: INSERT INTO PO_ACTION_HISTORY

366: -- SQL What: Bulk insert into Action History
367: -- SQL Why : To create action history for the new GBPA's
368: -- SQL Join: object_id, object_type_code
369: FORALL i IN 1.. p_po_header_ids.COUNT
370: INSERT INTO PO_ACTION_HISTORY
371: (object_id,
372: object_type_code,
373: object_sub_type_code,
374: sequence_num,

Line 418: FROM PO_ACTION_HISTORY POAH

414: NULL -- program_date
415: FROM DUAL
416: WHERE NOT EXISTS
417: (SELECT 'Action History Record alreday exists'
418: FROM PO_ACTION_HISTORY POAH
419: WHERE POAH.object_id = p_po_header_ids(i)
420: AND POAH.object_type_code = 'PA'
421: AND POAH.object_sub_type_code = 'BLANKET');
422: