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_CYCLE_ACTIONS

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

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

Line 672: so_cycle_actions sca,

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

Line 841: so_cycle_actions sca,

837: spr.action_id,
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

Line 850: (SELECT action_id FROM so_cycle_actions

846: AND spr.action_id = sa.action_id
847: AND sca.action_id = sa2.action_id
848: AND decode(sa2.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
849: AND spr.action_id IN
850: (SELECT action_id FROM so_cycle_actions
851: WHERE cycle_id = p_cycle_id)
852: AND spr.cycle_action_id IN
853: (SELECT cycle_action_id FROM so_Cycle_actions
854: WHERE cycle_id = p_cycle_id

Line 853: (SELECT cycle_action_id FROM so_Cycle_actions

849: AND spr.action_id IN
850: (SELECT action_id FROM so_cycle_actions
851: WHERE cycle_id = p_cycle_id)
852: AND spr.cycle_action_id IN
853: (SELECT cycle_action_id FROM so_Cycle_actions
854: WHERE cycle_id = p_cycle_id
855: AND (cycle_id, p_item_type) in
856: (SELECT cycle_id, item_type FROM oe_upgrade_wf_vld_cyc ) )
857: AND decode(sa.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type

Line 875: (not exists (select 'x' from so_action_pre_reqs x, so_cycle_actions y

871: /* Inventory Interface and Comfirm Line should not exist in the same flow */
872: /*
873: and (sa.action_id <> 11 or
874: (sa.action_id = 11 and sa2.action_id <> 8) or
875: (not exists (select 'x' from so_action_pre_reqs x, so_cycle_actions y
876: where x.cycle_action_id = y.cycle_action_id
877: and y.cycle_id = p_cycle_id
878: and x.action_id <> 11
879: and y.action_id = 8)

Line 925: FROM so_cycle_actions

921: action_id
922: INTO
923: v_cycle_id,
924: v_action_id
925: FROM so_cycle_actions
926: WHERE cycle_action_id = v_cycle_Action_id;
927:
928: v_process_name := 'UPG_PN_'||p_item_type||'_'
929: ||p_line_type||'_'||to_char(v_cycle_id);

Line 1159: FROM so_action_pre_reqs a, so_Cycle_actions b

1155: a.cycle_action_id,
1156: a.result_id,
1157: a.action_id hdr_action_id,
1158: a.group_number
1159: FROM so_action_pre_reqs a, so_Cycle_actions b
1160: WHERE b.cycle_id = p_cycle_id
1161: AND ((a.action_id IN (SELECT action_id
1162: FROM oe_upgrade_wf_act_map
1163: WHERE line_type IN ( p_line_type , 'BOTH')) )

Line 1178: FROM so_cycle_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
1178: FROM so_cycle_actions
1179: WHERE action_id in
1180: (SELECT action_id
1181: FROM so_actions
1182: WHERE result_table = 'SO_LINES'))

Line 1186: FROM so_Cycle_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
1186: FROM so_Cycle_actions
1187: WHERE (cycle_id, 'OEOL') IN
1188: (SELECT cycle_id,item_type
1189: FROM oe_upgrade_wf_vld_cyc ) );
1190:

Line 1923: FROM so_cycle_actions

1919: INTO
1920: v_process_name,
1921: v_instance_label,
1922: v_cycle_id
1923: FROM so_cycle_actions
1924: WHERE cycle_action_id = c2.cycle_action_id;
1925:
1926: SELECT wf_process_activities_s.nextval
1927: INTO v_last_instance_id

Line 2068: so_cycle_actions ca,

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

Line 2453: where cycle_id in (select cycle_id from so_cycle_actions

2449: v_level_error number := 0;
2450:
2451: cursor c1 is
2452: select cycle_id from so_cycles
2453: where cycle_id in (select cycle_id from so_cycle_actions
2454: where action_id = 7)
2455: and cycle_id not in (select cycle_id from so_cycle_actions
2456: where action_id in (3, 13))
2457: and cycle_id = p_cycle_id;

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

2451: cursor c1 is
2452: select cycle_id from so_cycles
2453: where cycle_id in (select cycle_id from so_cycle_actions
2454: where action_id = 7)
2455: and cycle_id not in (select cycle_id from so_cycle_actions
2456: where action_id in (3, 13))
2457: and cycle_id = p_cycle_id;
2458:
2459: cursor c3 is

Line 2539: where cycle_id in (select cycle_id from so_cycle_actions

2535: v_mfg_instance_id number;
2536:
2537: cursor c1 is
2538: select cycle_id from so_cycles
2539: where cycle_id in (select cycle_id from so_cycle_actions
2540: where action_id = 15);
2541: cursor c3 is
2542: select to_process_activity
2543: from wf_activity_transitions

Line 2702: where cycle_id in (select cycle_id from so_cycle_actions

2698:
2699:
2700: Cursor c1 is
2701: select cycle_id from so_cycles
2702: where cycle_id in (select cycle_id from so_cycle_actions
2703: where action_id in (2,3,4,11,16))
2704: and cycle_id in (select cycle_id from so_cycle_actions
2705: where action_id = 13)
2706: and cycle_id = p_cycle_id;

Line 2704: and cycle_id in (select cycle_id from so_cycle_actions

2700: Cursor c1 is
2701: select cycle_id from so_cycles
2702: where cycle_id in (select cycle_id from so_cycle_actions
2703: where action_id in (2,3,4,11,16))
2704: and cycle_id in (select cycle_id from so_cycle_actions
2705: where action_id = 13)
2706: and cycle_id = p_cycle_id;
2707:
2708: cursor c3 is

Line 3572: (select a.cycle_id from so_cycle_actions a

3568: CURSOR c1 IS
3569: SELECT cycle_id
3570: FROM so_cycles
3571: WHERE cycle_id NOT IN
3572: (select a.cycle_id from so_cycle_actions a
3573: where exists (Select action_id
3574: from so_cycle_actions
3575: where cycle_id = a.cycle_id
3576: and action_id = 11)

Line 3574: from so_cycle_actions

3570: FROM so_cycles
3571: WHERE cycle_id NOT IN
3572: (select a.cycle_id from so_cycle_actions a
3573: where exists (Select action_id
3574: from so_cycle_actions
3575: where cycle_id = a.cycle_id
3576: and action_id = 11)
3577: and not exists (Select action_id
3578: from so_cycle_actions

Line 3578: from so_cycle_actions

3574: from so_cycle_actions
3575: where cycle_id = a.cycle_id
3576: and action_id = 11)
3577: and not exists (Select action_id
3578: from so_cycle_actions
3579: where cycle_id = a.cycle_id
3580: and action_id = 3))
3581: AND cycle_id NOT IN
3582: (select a.cycle_id from so_cycle_actions a

Line 3582: (select a.cycle_id from so_cycle_actions a

3578: from so_cycle_actions
3579: where cycle_id = a.cycle_id
3580: and action_id = 3))
3581: AND cycle_id NOT IN
3582: (select a.cycle_id from so_cycle_actions a
3583: where exists (Select action_id
3584: from so_cycle_actions
3585: where cycle_id = a.cycle_id
3586: and action_id = 17)

Line 3584: from so_cycle_actions

3580: and action_id = 3))
3581: AND cycle_id NOT IN
3582: (select a.cycle_id from so_cycle_actions a
3583: where exists (Select action_id
3584: from so_cycle_actions
3585: where cycle_id = a.cycle_id
3586: and action_id = 17)
3587: and ( exists (Select action_id
3588: from so_cycle_actions

Line 3588: from so_cycle_actions

3584: from so_cycle_actions
3585: where cycle_id = a.cycle_id
3586: and action_id = 17)
3587: and ( exists (Select action_id
3588: from so_cycle_actions
3589: where cycle_id = a.cycle_id
3590: and action_id = 13)))
3591: AND cycle_id NOT IN
3592: (SELECT cycle_id

Line 3597: (select a.cycle_id from so_cycle_actions a

3593: FROM oe_upgrade_log
3594: WHERE cycle_id is not null
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

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 3604: (select a.cycle_id from so_cycle_actions a

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
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

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 3611: from so_cycle_actions

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
3611: from so_cycle_actions
3612: where action_id in (5,6) )
3613: AND cycle_id not in (select distinct sca.cycle_id
3614: from so_cycle_actions sca
3615: where sca.cycle_action_id in (select sapr.cycle_action_id

Line 3614: from so_cycle_actions sca

3610: AND cycle_id not in (select cycle_id
3611: from so_cycle_actions
3612: where action_id in (5,6) )
3613: AND cycle_id not in (select distinct sca.cycle_id
3614: from so_cycle_actions sca
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

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 3704: FROM so_cycle_actions

3700: --action 15 is manufacturing release
3701: BEGIN
3702: SELECT 'Y'
3703: INTO v_cfg_item
3704: FROM so_cycle_actions
3705: WHERE action_id = 15
3706: AND cycle_id = c4.cycle_id;
3707: EXCEPTION
3708: WHEN NO_DATA_FOUND THEN

Line 3771: FROM so_cycle_actions

3767: IF v_vld_lin_flag = 'Y' THEN
3768: BEGIN
3769: SELECT 'Y'
3770: INTO v_cfg_item
3771: FROM so_cycle_actions
3772: WHERE action_id = 15
3773: AND cycle_id = c2.cycle_id;
3774: EXCEPTION
3775: WHEN NO_DATA_FOUND THEN