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_ACTIONS

Line 265: so_actions M,

261: 20 protect_level,
262: 20 custom_level,
263: M.description description
264: FROM
265: so_actions M,
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

Line 343: so_actions SA,

339: max(20) protect_level,
340: max(20) custom_level,
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',

Line 455: so_actions SA,

451: null function_type,
452: result_column result_column,
453: sa.action_id action_id
454: FROM
455: so_actions SA,
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

Line 673: so_actions soac,

669: soac.result_column result_column,
670: soac.action_approval approval
671: FROM
672: so_cycle_actions sca,
673: so_actions soac,
674: oe_upgrade_wf_act_map oemap
675: WHERE sca.cycle_id = p_cycle_id
676: AND sca.action_id = soac.action_id
677: AND sca.action_id = oemap.action_id (+)

Line 842: so_actions sa,

838: spr.result_id,
839: spr.group_number
840: FROM so_action_pre_reqs spr,
841: so_cycle_actions sca,
842: so_actions sa,
843: so_actions sa2
844: WHERE spr.cycle_action_id = sca.cycle_action_id
845: AND sca.cycle_id = p_cycle_id
846: AND spr.action_id = sa.action_id

Line 843: so_actions sa2

839: spr.group_number
840: FROM so_action_pre_reqs spr,
841: so_cycle_actions sca,
842: so_actions sa,
843: so_actions sa2
844: WHERE spr.cycle_action_id = sca.cycle_action_id
845: AND sca.cycle_id = p_cycle_id
846: AND spr.action_id = sa.action_id
847: AND sca.action_id = sa2.action_id

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)

Line 1173: FROM so_actions

1169: OR (b.action_id NOT IN (SELECT action_id
1170: FROM oe_upgrade_wf_act_map )))
1171: AND a.action_id IN
1172: (SELECT action_id
1173: FROM so_actions
1174: WHERE result_table = 'SO_HEADERS'
1175: AND (action_id = 1 or action_id not in (select action_id from oe_upgrade_wf_act_map)))
1176: AND a.cycle_action_id IN
1177: (SELECT cycle_action_id

Line 1181: FROM so_actions

1177: (SELECT cycle_action_id
1178: FROM so_cycle_actions
1179: WHERE action_id in
1180: (SELECT action_id
1181: FROM so_actions
1182: WHERE result_table = 'SO_LINES'))
1183: AND a.cycle_action_id = b.cycle_action_id
1184: AND a.cycle_action_id IN
1185: (SELECT cycle_action_id

Line 2067: FROM so_actions a,

2063: ||p_line_type||'_'||to_char(p_cycle_id) proc_name,
2064: nvl(m.activity_name,
2065: 'UPG_ILN_'||to_char(a.action_id)) instance_label,
2066: nvl(m.activity_seq, 0) act_seq
2067: FROM so_actions a,
2068: so_cycle_actions ca,
2069: oe_upgrade_wf_act_map m
2070: WHERE ca.cycle_id = p_cycle_id
2071: AND ca.action_id = a.action_id

Line 2084: FROM so_actions a,

2080: nvl(m.activity_seq, 0) act_seq,
2081: nvl(m.activity_name,
2082: 'UPG_ILN_'||to_char(a.action_id)) instance_label,
2083: nvl(m.activity_result,c2.result_code) act_result
2084: FROM so_actions a,
2085: oe_upgrade_wf_act_map m
2086: WHERE a.action_id = c2.action_id
2087: AND a.action_id = m.action_id(+)
2088: ORDER BY act_seq desc;

Line 3599: from so_cycle_actions sca, so_actions sa

3595: )
3596: AND cycle_id NOT IN
3597: (select a.cycle_id from so_cycle_actions a
3598: where not exists (Select sca.action_id
3599: from so_cycle_actions sca, so_actions sa
3600: where sca.cycle_id = a.cycle_id
3601: and sa.action_id = sca.action_id
3602: and sa.result_table = 'SO_LINES'))
3603: AND cycle_id NOT IN

Line 3606: from so_cycle_actions sca, so_actions sa

3602: and sa.result_table = 'SO_LINES'))
3603: AND cycle_id NOT IN
3604: (select a.cycle_id from so_cycle_actions a
3605: where not exists (Select sca.action_id
3606: from so_cycle_actions sca, so_actions sa
3607: where sca.cycle_id = a.cycle_id
3608: and sa.action_id = sca.action_id
3609: and sa.result_table = 'SO_HEADERS'))
3610: AND cycle_id not in (select cycle_id

Line 3621: from so_cycle_actions sa, so_action_pre_reqs p, so_actions a

3617: where (sapr.action_id, sapr.result_id) not in
3618: (select action_id, result_id
3619: from so_action_results)))
3620: AND cycle_id not in (select distinct sa.cycle_id
3621: from so_cycle_actions sa, so_action_pre_reqs p, so_actions a
3622: where a.result_table = 'SO_LINES'
3623: and sa.action_id = a.action_id
3624: and p.cycle_action_id = sa.cycle_action_id
3625: and exists (select 'more than 1 group'

Line 3635: from so_action_pre_reqs p3, so_actions a1

3631: where p2.cycle_action_id = sa.cycle_action_id
3632: group by p2.cycle_action_id, p2.group_number
3633: having count(*) > 1
3634: and exists (select 'Group has header action'
3635: from so_action_pre_reqs p3, so_actions a1
3636: where p3.cycle_action_id = p2.cycle_action_id
3637: and p3.group_number = p2.group_number
3638: and p3.action_id = a1.action_id
3639: and a1.result_table = 'SO_HEADERS')))

Line 4055: so_actions sa

4051: v_result_column,
4052: v_action_id,
4053: v_result_Type
4054: from
4055: so_actions sa
4056: where sa.action_id = to_number(substr(c2.name,8,10))
4057: and substr(c2.name,8,10) between '0000000000' and '9999999999';
4058: exception
4059: when others then