APPS.OE_UPGRADE_WF2 dependencies on SO_ACTION_PRE_REQS

Line 689: AND ( sca.action_id in (SELECT action_id from so_action_pre_reqs)

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',
692: 'SO_LINES','OEOL','ERROR') = p_item_type;
693:

Line 690: OR sca.cycle_action_id in (SELECT cycle_action_id from so_action_pre_reqs))

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',
692: 'SO_LINES','OEOL','ERROR') = p_item_type;
693:
694: v_process_name VARCHAR2(80);

Line 709: FROM so_action_pre_reqs

705: an action with a pre-req of Enter -Booked (1-1) */
706: IF c2.activity_name = 'UPG_BOOK_PROCESS_ASYNCH' THEN
707: SELECT count(1)
708: INTO v_booked_count
709: FROM so_action_pre_reqs
710: WHERE action_id = 1
711: AND cycle_action_id in (SELECT cycle_action_id
712: FROM so_cycle_actions
713: WHERE cycle_id = p_cycle_id)

Line 849: To populate the local table oe_action_pre_reqs from so_action_pre_reqs

845: End Create_Process_Activity;
846:
847:
848: /*
849: To populate the local table oe_action_pre_reqs from so_action_pre_reqs
850: This takes care of the putting an AND activitiy in the appropriate place.
851: */
852:
853: PROCEDURE Create_Activity_And

Line 866: FROM so_action_pre_reqs spr,

862: spr.cycle_action_id,
863: spr.action_id,
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

Line 1173: FROM so_action_pre_reqs a, so_Cycle_actions b

1169: a.cycle_action_id,
1170: a.result_id,
1171: a.action_id hdr_action_id,
1172: a.group_number
1173: FROM so_action_pre_reqs a, so_Cycle_actions b
1174: WHERE b.cycle_id = p_cycle_id
1175: AND ((a.action_id IN (SELECT action_id
1176: FROM oe_upgrade_wf_act_map
1177: WHERE line_type IN ( p_line_type , 'BOTH')) )