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.OE_UPGRADE_WF2 dependencies on SO_RESULTS

Line 350: so_results SR,

346: max(SR.Description) description
347: FROM
348: so_actions SA,
349: so_action_results SAR,
350: so_results SR,
351: oe_upgrade_wf_act_map U
352: WHERE decode(SA.result_table,'SO_HEADERS','OEOH',
353: 'SO_LINES','OEOL','ERROR') = p_item_type
354: AND SA.action_id = SAR.action_id

Line 885: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes

881: FROM so_Cycle_actions
882: WHERE cycle_id = p_cycle_id)
883: AND decode(sa.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
884: AND spr.result_id NOT IN
885: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes
886: WHERE type ='RESULT'
887: AND so_results.result_id = oe_upgrade_wf_obs_codes.name )
888: AND spr.action_id NOT IN
889: ( SELECT action_id FROM so_actions a, oe_upgrade_wf_obs_codes b

Line 887: AND so_results.result_id = oe_upgrade_wf_obs_codes.name )

883: AND decode(sa.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
884: AND spr.result_id NOT IN
885: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes
886: WHERE type ='RESULT'
887: AND so_results.result_id = oe_upgrade_wf_obs_codes.name )
888: AND spr.action_id NOT IN
889: ( SELECT action_id FROM so_actions a, oe_upgrade_wf_obs_codes b
890: WHERE type = 'ACTION'
891: AND a.action_id = b.name )