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_WF dependencies on SO_RESULTS

Line 345: so_results SR,

341: max(SR.Description) description
342: FROM
343: so_actions SA,
344: so_action_results SAR,
345: so_results SR,
346: oe_upgrade_wf_act_map U
347: WHERE decode(SA.result_table,'SO_HEADERS','OEOH',
348: 'SO_LINES','OEOL','ERROR') = p_item_type
349: AND SA.action_id = SAR.action_id

Line 859: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes

855: AND (cycle_id, p_item_type) in
856: (SELECT cycle_id, item_type FROM oe_upgrade_wf_vld_cyc ) )
857: AND decode(sa.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
858: AND spr.result_id NOT IN
859: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes
860: WHERE type ='RESULT'
861: AND so_results.result_id = oe_upgrade_wf_obs_codes.name )
862: AND spr.action_id NOT IN
863: ( SELECT action_id FROM so_actions a, oe_upgrade_wf_obs_codes b

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

857: AND decode(sa.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
858: AND spr.result_id NOT IN
859: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes
860: WHERE type ='RESULT'
861: AND so_results.result_id = oe_upgrade_wf_obs_codes.name )
862: AND spr.action_id NOT IN
863: ( SELECT action_id FROM so_actions a, oe_upgrade_wf_obs_codes b
864: WHERE type = 'ACTION'
865: AND a.action_id = b.name )