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 OE_UPGRADE_WF_OBS_CODES

Line 270: ( SELECT name from oe_upgrade_wf_obs_codes

266: oe_upgrade_wf_act_map U
267: WHERE decode(M.result_table,'SO_HEADERS','OEOH',
268: 'SO_LINES','OEOL','ERROR') = p_item_type
269: AND M.action_id not in
270: ( SELECT name from oe_upgrade_wf_obs_codes
271: WHERE type = 'ACTION' )
272: AND M.action_id = U.action_id(+)
273: AND U.action_id is null;
274:

Line 352: ( SELECT name from oe_upgrade_wf_obs_codes

348: 'SO_LINES','OEOL','ERROR') = p_item_type
349: AND SA.action_id = SAR.action_id
350: AND SAR.result_id = SR.result_id
351: AND SR.result_id not in
352: ( SELECT name from oe_upgrade_wf_obs_codes
353: WHERE type = 'RESULT' )
354: AND SA.action_id = U.action_id (+)
355: AND U.action_id is null
356: GROUP BY

Line 460: ( SELECT name from oe_upgrade_wf_obs_codes

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

Line 682: ( SELECT name FROM oe_upgrade_wf_obs_codes

678: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
679: WHERE line_type in ( p_line_type , 'BOTH')) )
680: OR (soac.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
681: AND SOAC.action_id not in
682: ( SELECT name FROM oe_upgrade_wf_obs_codes
683: WHERE type = 'ACTION' )
684: AND ( sca.action_id in (SELECT action_id from so_action_pre_reqs)
685: OR sca.cycle_action_id in (SELECT cycle_action_id from so_action_pre_reqs))
686: AND decode(soac.result_table,'SO_HEADERS','OEOH',

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 )

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

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