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_WF2 dependencies on SO_CYCLE_ACTIONS

Line 469: AND sa.action_id in (select action_id from so_cycle_actions);

465: ( SELECT name from oe_upgrade_wf_obs_codes
466: WHERE type = 'ACTION' )
467: AND decode(result_table,'SO_HEADERS','OEOH',
468: 'SO_LINES','OEOL','ERROR') = p_item_type
469: AND sa.action_id in (select action_id from so_cycle_actions);
470:
471: v_message varchar2(80);
472: v_name VARCHAR2(80);
473: v_version NUMBER;

Line 677: so_cycle_actions sca,

673: decode(soac.action_approval,'Y','NOTIFICATION_APPROVER','') perform_role,
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

Line 712: FROM so_cycle_actions

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)
714: AND result_id = 1;
715:
716: IF v_booked_count = 0 THEN

Line 867: so_cycle_actions sca,

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
871: AND sca.cycle_id = p_cycle_id

Line 877: FROM so_cycle_actions

873: AND sca.action_id = sa2.action_id
874: AND decode(sa2.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
875: AND spr.action_id IN
876: (SELECT action_id
877: FROM so_cycle_actions
878: WHERE cycle_id = p_cycle_id)
879: AND spr.cycle_action_id IN
880: (SELECT cycle_action_id
881: FROM so_Cycle_actions

Line 881: FROM so_Cycle_actions

877: FROM so_cycle_actions
878: WHERE cycle_id = p_cycle_id)
879: AND spr.cycle_action_id IN
880: (SELECT cycle_action_id
881: FROM so_Cycle_actions
882: WHERE cycle_id = p_cycle_id)
883: AND decode(sa.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
884: AND spr.result_id NOT IN
885: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes

Line 939: FROM so_cycle_actions

935: action_id
936: INTO
937: v_cycle_id,
938: v_action_id
939: FROM so_cycle_actions
940: WHERE cycle_action_id = v_cycle_Action_id;
941:
942: v_process_name := 'UPG_PN_'||p_item_type||'_'
943: ||p_line_type||'_'||to_char(v_cycle_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')) )

Line 1192: FROM so_cycle_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
1192: FROM so_cycle_actions
1193: WHERE action_id in
1194: (SELECT action_id
1195: FROM so_actions
1196: WHERE result_table = 'SO_LINES'))

Line 1200: FROM so_Cycle_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
1200: FROM so_Cycle_actions
1201: WHERE cycle_id = p_cycle_id);
1202:
1203: CURSOR c3 IS
1204: SELECT

Line 1935: FROM so_cycle_actions

1931: INTO
1932: v_process_name,
1933: v_instance_label,
1934: v_cycle_id
1935: FROM so_cycle_actions
1936: WHERE cycle_action_id = c2.cycle_action_id;
1937:
1938: SELECT wf_process_activities_s.nextval
1939: INTO v_last_instance_id

Line 2080: so_cycle_actions ca,

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
2084: AND ca.cycle_action_id = c2.cycle_action_id

Line 2097: so_cycle_actions ca,

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
2101: AND ca.cycle_id = p_cycle_id

Line 2468: where cycle_id in (select cycle_id from so_cycle_actions

2464: v_level_error number := 0;
2465:
2466: cursor c1 is
2467: select cycle_id from so_cycles
2468: where cycle_id in (select cycle_id from so_cycle_actions
2469: where action_id = 7)
2470: and cycle_id not in (select cycle_id from so_cycle_actions
2471: where action_id in (3, 13))
2472: and cycle_id = p_cycle_id;

Line 2470: and cycle_id not in (select cycle_id from so_cycle_actions

2466: cursor c1 is
2467: select cycle_id from so_cycles
2468: where cycle_id in (select cycle_id from so_cycle_actions
2469: where action_id = 7)
2470: and cycle_id not in (select cycle_id from so_cycle_actions
2471: where action_id in (3, 13))
2472: and cycle_id = p_cycle_id;
2473:
2474: cursor c3 is

Line 2554: where cycle_id in (select cycle_id from so_cycle_actions

2550: v_mfg_instance_id number;
2551:
2552: cursor c1 is
2553: select cycle_id from so_cycles
2554: where cycle_id in (select cycle_id from so_cycle_actions
2555: where action_id = 15);
2556: cursor c3 is
2557: select to_process_activity
2558: from wf_activity_transitions

Line 2717: where cycle_id in (select cycle_id from so_cycle_actions

2713:
2714:
2715: Cursor c1 is
2716: select cycle_id from so_cycles
2717: where cycle_id in (select cycle_id from so_cycle_actions
2718: where action_id in (2,3,4,11,16))
2719: and cycle_id in (select cycle_id from so_cycle_actions
2720: where action_id = 13)
2721: and cycle_id = p_cycle_id;

Line 2719: and cycle_id in (select cycle_id from so_cycle_actions

2715: Cursor c1 is
2716: select cycle_id from so_cycles
2717: where cycle_id in (select cycle_id from so_cycle_actions
2718: where action_id in (2,3,4,11,16))
2719: and cycle_id in (select cycle_id from so_cycle_actions
2720: where action_id = 13)
2721: and cycle_id = p_cycle_id;
2722:
2723: cursor c3 is

Line 3652: FROM so_cycle_actions

3648: --action 15 is manufacturing release
3649: BEGIN
3650: SELECT 'Y'
3651: INTO v_cfg_item
3652: FROM so_cycle_actions
3653: WHERE action_id = 15
3654: AND cycle_id = c4.cycle_id;
3655: EXCEPTION
3656: WHEN NO_DATA_FOUND THEN

Line 3688: FROM so_cycle_actions

3684:
3685: BEGIN
3686: SELECT 'Y'
3687: INTO v_cfg_item
3688: FROM so_cycle_actions
3689: WHERE action_id = 15
3690: AND cycle_id = c2.cycle_id;
3691: EXCEPTION
3692: WHEN NO_DATA_FOUND THEN