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_ACTION_PRE_REQS

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

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)
685: OR sca.cycle_action_id in (SELECT cycle_action_id from so_action_pre_reqs))
686: AND decode(soac.result_table,'SO_HEADERS','OEOH',
687: 'SO_LINES','OEOL','ERROR') = p_item_type;
688:

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

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)
685: OR sca.cycle_action_id in (SELECT cycle_action_id from so_action_pre_reqs))
686: AND decode(soac.result_table,'SO_HEADERS','OEOH',
687: 'SO_LINES','OEOL','ERROR') = p_item_type;
688:
689: v_process_name VARCHAR2(80);

Line 823: To populate the local table oe_action_pre_reqs from so_action_pre_reqs

819: End Create_Process_Activity;
820:
821:
822: /*
823: To populate the local table oe_action_pre_reqs from so_action_pre_reqs
824: This takes care of the putting an AND activitiy in the appropriate place.
825: */
826:
827: PROCEDURE Create_Activity_And

Line 840: FROM so_action_pre_reqs spr,

836: spr.cycle_action_id,
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

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 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 3557: is used as a pre-req in so_action_pre_reqs

3553: 7. Filter out nocopy cycles that have cancel_line (6)in them
3554:
3555: 8. Filter out nocopy cycles that have no action results in so_action_results, but
3556:
3557: is used as a pre-req in so_action_pre_reqs
3558: 9. Filter out nocopy cycles that has the following attribute:
3559:
3560: i More than one group in its pre-requisites (OR condition)
3561: AND

Line 3616: from so_action_pre_reqs sapr

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
3619: from so_action_results)))
3620: AND cycle_id not in (select distinct sa.cycle_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 3626: from so_action_pre_reqs p1

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'
3626: from so_action_pre_reqs p1
3627: where p1.cycle_action_id = sa.cycle_action_id
3628: having count(distinct group_number) > 1)
3629: and exists (select 'Group has more than 1 row'
3630: from so_action_pre_reqs p2

Line 3630: from so_action_pre_reqs p2

3626: from so_action_pre_reqs p1
3627: where p1.cycle_action_id = sa.cycle_action_id
3628: having count(distinct group_number) > 1)
3629: and exists (select 'Group has more than 1 row'
3630: from so_action_pre_reqs p2
3631: where p2.cycle_action_id = sa.cycle_action_id
3632: group by p2.cycle_action_id, p2.group_number
3633: having count(*) > 1
3634: and exists (select 'Group has header action'

Line 3635: from so_action_pre_reqs p3, so_actions a1

3631: where p2.cycle_action_id = sa.cycle_action_id
3632: group by p2.cycle_action_id, p2.group_number
3633: having count(*) > 1
3634: and exists (select 'Group has header action'
3635: from so_action_pre_reqs p3, so_actions a1
3636: where p3.cycle_action_id = p2.cycle_action_id
3637: and p3.group_number = p2.group_number
3638: and p3.action_id = a1.action_id
3639: and a1.result_table = 'SO_HEADERS')))