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 OE_UPGRADE_WF_ACT_MAP

Line 22: FROM oe_upgrade_wf_act_map

18:
19: SELECT activity_name,activity_result
20: INTO v_pre_activity,
21: v_pre_result
22: FROM oe_upgrade_wf_act_map
23: WHERE activity_seq = p_sequence_id - 1
24: AND action_id = p_action_id;
25: END IF;
26:

Line 43: FROM oe_upgrade_wf_act_map

39:
40: BEGIN
41: SELECT activity_name
42: INTO r_post_activity_name
43: FROM oe_upgrade_wf_act_map
44: WHERE activity_seq = p_sequence_id + 1
45: AND action_id = p_action_id;
46:
47: RETURN (r_post_activity_name);

Line 271: oe_upgrade_wf_act_map U

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
275: ( SELECT name from oe_upgrade_wf_obs_codes

Line 351: oe_upgrade_wf_act_map U

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',
353: 'SO_LINES','OEOL','ERROR') = p_item_type
354: AND SA.action_id = SAR.action_id
355: AND SAR.result_id = SR.result_id

Line 461: oe_upgrade_wf_act_map U

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
465: ( SELECT name from oe_upgrade_wf_obs_codes

Line 679: oe_upgrade_wf_act_map oemap

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 (+)
683: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map

Line 683: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map

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 (+)
683: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
684: WHERE line_type in ( p_line_type , 'BOTH')) )
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

Line 685: OR (soac.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))

681: AND sca.action_id = soac.action_id
682: AND sca.action_id = oemap.action_id (+)
683: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
684: WHERE line_type in ( p_line_type , 'BOTH')) )
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)

Line 899: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map

895: /* Transition from Ship confirm to Inv. Intfce. obsoleted */
896: OR (sa.action_id = 3 and sa2.action_id <> 11))
897: AND ( SPR.ACTION_ID NOT IN (2,3,4,11,16) or
898: (spr.action_id in (2,3,4,11,16) and sca.action_id not in (2,3,4,11,16)) )
899: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
900: WHERE line_type in ( p_line_type , 'BOTH')) )
901: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
902: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
903: WHERE line_type in ( p_line_type , 'BOTH')) )

Line 901: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))

897: AND ( SPR.ACTION_ID NOT IN (2,3,4,11,16) or
898: (spr.action_id in (2,3,4,11,16) and sca.action_id not in (2,3,4,11,16)) )
899: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
900: WHERE line_type in ( p_line_type , 'BOTH')) )
901: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
902: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
903: WHERE line_type in ( p_line_type , 'BOTH')) )
904: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
905: ORDER BY spr.cycle_action_id, spr.group_number;

Line 902: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map

898: (spr.action_id in (2,3,4,11,16) and sca.action_id not in (2,3,4,11,16)) )
899: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
900: WHERE line_type in ( p_line_type , 'BOTH')) )
901: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
902: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
903: WHERE line_type in ( p_line_type , 'BOTH')) )
904: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
905: ORDER BY spr.cycle_action_id, spr.group_number;
906:

Line 904: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))

900: WHERE line_type in ( p_line_type , 'BOTH')) )
901: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
902: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
903: WHERE line_type in ( p_line_type , 'BOTH')) )
904: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
905: ORDER BY spr.cycle_action_id, spr.group_number;
906:
907: v_cycle_action_id NUMBER;
908: v_cycle_id NUMBER;

Line 1176: FROM oe_upgrade_wf_act_map

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')) )
1178: OR (a.action_id NOT IN (SELECT action_id
1179: FROM oe_upgrade_wf_act_map )))
1180: AND ((b.action_id IN (SELECT action_id

Line 1179: FROM oe_upgrade_wf_act_map )))

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')) )
1178: OR (a.action_id NOT IN (SELECT action_id
1179: FROM oe_upgrade_wf_act_map )))
1180: AND ((b.action_id IN (SELECT action_id
1181: FROM oe_upgrade_wf_act_map
1182: WHERE line_type IN ( p_line_type , 'BOTH')) )
1183: OR (b.action_id NOT IN (SELECT action_id

Line 1181: FROM oe_upgrade_wf_act_map

1177: WHERE line_type IN ( p_line_type , 'BOTH')) )
1178: OR (a.action_id NOT IN (SELECT action_id
1179: FROM oe_upgrade_wf_act_map )))
1180: AND ((b.action_id IN (SELECT action_id
1181: FROM oe_upgrade_wf_act_map
1182: WHERE line_type IN ( p_line_type , 'BOTH')) )
1183: OR (b.action_id NOT IN (SELECT action_id
1184: FROM oe_upgrade_wf_act_map )))
1185: AND a.action_id IN

Line 1184: FROM oe_upgrade_wf_act_map )))

1180: AND ((b.action_id IN (SELECT action_id
1181: FROM oe_upgrade_wf_act_map
1182: WHERE line_type IN ( p_line_type , 'BOTH')) )
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'

Line 1189: AND (action_id = 1 or action_id not in (select action_id 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
1192: FROM so_cycle_actions
1193: WHERE action_id in

Line 2081: oe_upgrade_wf_act_map m

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
2085: AND a.action_id = m.action_id(+)

Line 2098: oe_upgrade_wf_act_map m

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
2102: AND a.action_id = m.action_id(+)

Line 2188: FROM oe_upgrade_wf_act_map

2184: -- dbms_output.put_line('======================='||to_char(v_error_level));
2185: IF c6.act_seq <> 0 THEN
2186: SELECT max(activity_seq)
2187: INTO v_max_seq
2188: FROM oe_upgrade_wf_act_map
2189: WHERE action_id = c6.action_id_c5;
2190: END IF;
2191:
2192: v_error_level := 2101;

Line 2274: FROM oe_upgrade_wf_act_map

2270: FOR c6 IN c5 LOOP
2271: IF c6.act_seq <> 0 THEN
2272: SELECT max(activity_seq)
2273: INTO v_max_seq
2274: FROM oe_upgrade_wf_act_map
2275: WHERE action_id = c6.action_id_c5;
2276: END IF;
2277:
2278: v_error_level := 2109;