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 OE_UPGRADE_WF_OBS_CODES

Line 275: ( SELECT name from oe_upgrade_wf_obs_codes

271: oe_upgrade_wf_act_map U
272: WHERE decode(M.result_table,'SO_HEADERS','OEOH',
273: 'SO_LINES','OEOL','ERROR') = p_item_type
274: AND M.action_id not in
275: ( SELECT name from oe_upgrade_wf_obs_codes
276: WHERE type = 'ACTION' )
277: AND M.action_id = U.action_id(+)
278: AND U.action_id is null;
279:

Line 357: ( SELECT name from oe_upgrade_wf_obs_codes

353: 'SO_LINES','OEOL','ERROR') = p_item_type
354: AND SA.action_id = SAR.action_id
355: AND SAR.result_id = SR.result_id
356: AND SR.result_id not in
357: ( SELECT name from oe_upgrade_wf_obs_codes
358: WHERE type = 'RESULT' )
359: AND SA.action_id = U.action_id (+)
360: AND U.action_id is null
361: GROUP BY

Line 465: ( SELECT name from oe_upgrade_wf_obs_codes

461: oe_upgrade_wf_act_map U
462: WHERE SA.action_id = U.action_id(+)
463: AND U.action_id is null
464: AND SA.action_id not in
465: ( SELECT name from oe_upgrade_wf_obs_codes
466: WHERE type = 'ACTION' )
467: AND decode(result_table,'SO_HEADERS','OEOH',
468: 'SO_LINES','OEOL','ERROR') = p_item_type
469: AND sa.action_id in (select action_id from so_cycle_actions);

Line 687: ( SELECT name FROM oe_upgrade_wf_obs_codes

683: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
684: WHERE line_type in ( p_line_type , 'BOTH')) )
685: OR (soac.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
686: AND SOAC.action_id not in
687: ( SELECT name FROM oe_upgrade_wf_obs_codes
688: WHERE type = 'ACTION' )
689: AND ( sca.action_id in (SELECT action_id from so_action_pre_reqs)
690: OR sca.cycle_action_id in (SELECT cycle_action_id from so_action_pre_reqs))
691: AND decode(soac.result_table,'SO_HEADERS','OEOH',

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 )

Line 889: ( SELECT action_id FROM so_actions a, oe_upgrade_wf_obs_codes b

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 )
892: /* Transition from Pick Release and Backorder Release obsoleted */
893: AND spr.action_id NOT IN (2,4)