[Home] [Help]
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',
348: 'SO_LINES','OEOL','ERROR') = p_item_type
480: v_error_level := 2031;
481:
482: v_fyi_flag := 'N';
483: begin
484: select 'N' into v_fyi_flag from so_action_results
485: where action_id = c2.action_id
486: and rownum = 1;
487: exception
488: when no_data_found then
3551: 6. Filter out nocopy cycles that have cancel_order(5) in them
3552:
3553: 7. Filter out nocopy cycles that have cancel_line (6)in them
3554:
3555: 8. Filter out nocopy cycles that have no action results in so_action_results, but
3556:
3557: is used as a pre-req in so_action_pre_reqs
3558: 9. Filter out nocopy cycles that has the following attribute:
3559:
3615: where sca.cycle_action_id in (select sapr.cycle_action_id
3616: from so_action_pre_reqs sapr
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
4061: v_action_id := NULL;
4062: end;
4063:
4064: begin
4065: select 'N' into v_fyi_Flag from so_action_results
4066: where action_id = v_action_id
4067: and rownum = 1;
4068: exception
4069: when no_data_found then