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 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 266: oe_upgrade_wf_act_map U

262: 20 custom_level,
263: M.description description
264: FROM
265: so_actions M,
266: oe_upgrade_wf_act_map U
267: WHERE decode(M.result_table,'SO_HEADERS','OEOH',
268: 'SO_LINES','OEOL','ERROR') = p_item_type
269: AND M.action_id not in
270: ( SELECT name from oe_upgrade_wf_obs_codes

Line 346: oe_upgrade_wf_act_map U

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
349: AND SA.action_id = SAR.action_id
350: AND SAR.result_id = SR.result_id

Line 456: oe_upgrade_wf_act_map U

452: result_column result_column,
453: sa.action_id action_id
454: FROM
455: so_actions SA,
456: oe_upgrade_wf_act_map U
457: WHERE SA.action_id = U.action_id(+)
458: AND U.action_id is null
459: AND SA.action_id not in
460: ( SELECT name from oe_upgrade_wf_obs_codes

Line 674: oe_upgrade_wf_act_map oemap

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
677: AND sca.action_id = oemap.action_id (+)
678: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map

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

674: oe_upgrade_wf_act_map oemap
675: WHERE sca.cycle_id = p_cycle_id
676: AND sca.action_id = soac.action_id
677: AND sca.action_id = oemap.action_id (+)
678: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
679: WHERE line_type in ( p_line_type , 'BOTH')) )
680: OR (soac.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
681: AND SOAC.action_id not in
682: ( SELECT name FROM oe_upgrade_wf_obs_codes

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

676: AND sca.action_id = soac.action_id
677: AND sca.action_id = oemap.action_id (+)
678: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
679: WHERE line_type in ( p_line_type , 'BOTH')) )
680: OR (soac.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
681: AND SOAC.action_id not in
682: ( SELECT name FROM oe_upgrade_wf_obs_codes
683: WHERE type = 'ACTION' )
684: AND ( sca.action_id in (SELECT action_id from so_action_pre_reqs)

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

881: )
882: */
883: AND ( SPR.ACTION_ID NOT IN (2,3,4,11,16) or
884: (spr.action_id in (2,3,4,11,16) and sca.action_id not in (2,3,4,11,16)) )
885: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
886: WHERE line_type in ( p_line_type , 'BOTH')) )
887: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
888: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
889: WHERE line_type in ( p_line_type , 'BOTH')) )

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

883: AND ( SPR.ACTION_ID NOT IN (2,3,4,11,16) or
884: (spr.action_id in (2,3,4,11,16) and sca.action_id not in (2,3,4,11,16)) )
885: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
886: WHERE line_type in ( p_line_type , 'BOTH')) )
887: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
888: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
889: WHERE line_type in ( p_line_type , 'BOTH')) )
890: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
891: ORDER BY spr.cycle_action_id, spr.group_number;

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

884: (spr.action_id in (2,3,4,11,16) and sca.action_id not in (2,3,4,11,16)) )
885: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
886: WHERE line_type in ( p_line_type , 'BOTH')) )
887: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
888: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
889: WHERE line_type in ( p_line_type , 'BOTH')) )
890: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
891: ORDER BY spr.cycle_action_id, spr.group_number;
892:

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

886: WHERE line_type in ( p_line_type , 'BOTH')) )
887: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
888: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
889: WHERE line_type in ( p_line_type , 'BOTH')) )
890: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
891: ORDER BY spr.cycle_action_id, spr.group_number;
892:
893: v_cycle_action_id NUMBER;
894: v_cycle_id NUMBER;

Line 1162: FROM oe_upgrade_wf_act_map

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')) )
1164: OR (a.action_id NOT IN (SELECT action_id
1165: FROM oe_upgrade_wf_act_map )))
1166: AND ((b.action_id IN (SELECT action_id

Line 1165: FROM oe_upgrade_wf_act_map )))

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')) )
1164: OR (a.action_id NOT IN (SELECT action_id
1165: FROM oe_upgrade_wf_act_map )))
1166: AND ((b.action_id IN (SELECT action_id
1167: FROM oe_upgrade_wf_act_map
1168: WHERE line_type IN ( p_line_type , 'BOTH')) )
1169: OR (b.action_id NOT IN (SELECT action_id

Line 1167: FROM oe_upgrade_wf_act_map

1163: WHERE line_type IN ( p_line_type , 'BOTH')) )
1164: OR (a.action_id NOT IN (SELECT action_id
1165: FROM oe_upgrade_wf_act_map )))
1166: AND ((b.action_id IN (SELECT action_id
1167: FROM oe_upgrade_wf_act_map
1168: WHERE line_type IN ( p_line_type , 'BOTH')) )
1169: OR (b.action_id NOT IN (SELECT action_id
1170: FROM oe_upgrade_wf_act_map )))
1171: AND a.action_id IN

Line 1170: FROM oe_upgrade_wf_act_map )))

1166: AND ((b.action_id IN (SELECT action_id
1167: FROM oe_upgrade_wf_act_map
1168: WHERE line_type IN ( p_line_type , 'BOTH')) )
1169: OR (b.action_id NOT IN (SELECT action_id
1170: FROM oe_upgrade_wf_act_map )))
1171: AND a.action_id IN
1172: (SELECT action_id
1173: FROM so_actions
1174: WHERE result_table = 'SO_HEADERS'

Line 1175: AND (action_id = 1 or action_id not in (select action_id from oe_upgrade_wf_act_map)))

1171: AND a.action_id IN
1172: (SELECT action_id
1173: FROM so_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

Line 2069: oe_upgrade_wf_act_map m

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

Line 2085: oe_upgrade_wf_act_map m

2081: nvl(m.activity_name,
2082: 'UPG_ILN_'||to_char(a.action_id)) instance_label,
2083: nvl(m.activity_result,c2.result_code) act_result
2084: FROM so_actions a,
2085: oe_upgrade_wf_act_map m
2086: WHERE a.action_id = c2.action_id
2087: AND a.action_id = m.action_id(+)
2088: ORDER BY act_seq desc;
2089:

Line 2173: FROM oe_upgrade_wf_act_map

2169: -- dbms_output.put_line('======================='||to_char(v_error_level));
2170: IF c6.act_seq <> 0 THEN
2171: SELECT max(activity_seq)
2172: INTO v_max_seq
2173: FROM oe_upgrade_wf_act_map
2174: WHERE action_id = c6.action_id_c5;
2175: END IF;
2176:
2177: v_error_level := 2101;

Line 2259: FROM oe_upgrade_wf_act_map

2255: FOR c6 IN c5 LOOP
2256: IF c6.act_seq <> 0 THEN
2257: SELECT max(activity_seq)
2258: INTO v_max_seq
2259: FROM oe_upgrade_wf_act_map
2260: WHERE action_id = c6.action_id_c5;
2261: END IF;
2262:
2263: v_error_level := 2109;