APPS.OE_UPGRADE_WF2 dependencies on SO_ACTIONS

Line 270: so_actions M,

266: 20 protect_level,
267: 20 custom_level,
268: M.description description
269: FROM
270: so_actions M,
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

Line 348: so_actions SA,

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

Line 460: so_actions SA,

456: null function_type,
457: result_column result_column,
458: sa.action_id action_id
459: FROM
460: so_actions SA,
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

Line 678: so_actions soac,

674: soac.result_column result_column,
675: soac.action_approval approval
676: FROM
677: so_cycle_actions sca,
678: so_actions soac,
679: oe_upgrade_wf_act_map oemap
680: WHERE sca.cycle_id = p_cycle_id
681: AND sca.action_id = soac.action_id
682: AND sca.action_id = oemap.action_id (+)

Line 868: so_actions sa,

864: spr.result_id,
865: spr.group_number
866: FROM so_action_pre_reqs spr,
867: so_cycle_actions sca,
868: so_actions sa,
869: so_actions sa2
870: WHERE spr.cycle_action_id = sca.cycle_action_id
871: AND sca.cycle_id = p_cycle_id
872: AND spr.action_id = sa.action_id

Line 869: so_actions sa2

865: spr.group_number
866: FROM so_action_pre_reqs spr,
867: so_cycle_actions sca,
868: so_actions sa,
869: so_actions sa2
870: WHERE spr.cycle_action_id = sca.cycle_action_id
871: AND sca.cycle_id = p_cycle_id
872: AND spr.action_id = sa.action_id
873: AND sca.action_id = sa2.action_id

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)

Line 1187: FROM so_actions

1183: OR (b.action_id NOT IN (SELECT action_id
1184: FROM oe_upgrade_wf_act_map )))
1185: AND a.action_id IN
1186: (SELECT action_id
1187: FROM so_actions
1188: WHERE result_table = 'SO_HEADERS'
1189: AND (action_id = 1 or action_id not in (select action_id from oe_upgrade_wf_act_map)))
1190: AND a.cycle_action_id IN
1191: (SELECT cycle_action_id

Line 1195: FROM so_actions

1191: (SELECT cycle_action_id
1192: FROM so_cycle_actions
1193: WHERE action_id in
1194: (SELECT action_id
1195: FROM so_actions
1196: WHERE result_table = 'SO_LINES'))
1197: AND a.cycle_action_id = b.cycle_action_id
1198: AND a.cycle_action_id IN
1199: (SELECT cycle_action_id

Line 2079: FROM so_actions a,

2075: ||p_line_type||'_'||to_char(p_cycle_id) proc_name,
2076: nvl(m.activity_name,
2077: 'UPG_ILN_'||to_char(ca.cycle_action_id)) instance_label,
2078: nvl(m.activity_seq, 0) act_seq
2079: FROM so_actions a,
2080: so_cycle_actions ca,
2081: oe_upgrade_wf_act_map m
2082: WHERE ca.cycle_id = p_cycle_id
2083: AND ca.action_id = a.action_id

Line 2096: FROM so_actions a,

2092: nvl(m.activity_seq, 0) act_seq,
2093: nvl(m.activity_name,
2094: 'UPG_ILN_'||to_char(ca.cycle_action_id)) instance_label,
2095: nvl(m.activity_result,c2.result_code) act_result
2096: FROM so_actions a,
2097: so_cycle_actions ca,
2098: oe_upgrade_wf_act_map m
2099: WHERE a.action_id = c2.action_id
2100: AND a.action_id = ca.action_id

Line 3963: so_actions sa

3959: v_result_column,
3960: v_action_id,
3961: v_result_Type
3962: from
3963: so_actions sa
3964: where sa.action_id = to_number(substr(c2.name,8,10))
3965: and substr(c2.name,8,10) between '0000000000' and '9999999999';
3966: exception
3967: when others then