APPS.EAM_OPERATIONS_JSP dependencies on WIP_OPERATION_NETWORKS

Line 30: FROM wip_operation_networks won, wip_operations wo

26: BEGIN
27: x_return_stat := 1;
28: -- Bug 3133704
29: SELECT count(operation_completed) into l_op_complete_count
30: FROM wip_operation_networks won, wip_operations wo
31: WHERE won.wip_entity_id = p_wip_entity_id
32: AND won.next_operation = p_operation_sequence_number
33: AND won.organization_id = p_organization_id
34: AND wo.wip_entity_id = p_wip_entity_id

Line 108: FOR cur_operation_record IN (select next_operation from wip_operation_networks where

104:
105: IF( nvl(upper(l_cur_completed_yn),'N') = 'Y') THEN
106: -- operation being contemplated by user is a uncomplete op. Hence check whether
107: -- all next ops are uncomplet or not
108: FOR cur_operation_record IN (select next_operation from wip_operation_networks where
109: wip_entity_id = p_wip_entity_id and
110: prior_operation = p_operation_sequence_number and
111: organization_id = p_organization_id) LOOP
112:

Line 127: FOR cur_operation_record IN (select prior_operation from wip_operation_networks where

123: END LOOP;
124: ELSIF( nvl(upper(l_cur_completed_yn),'N') = 'N') THEN
125: -- operation being contemplated by user is a complete op. Hence check whether
126: -- all previous ops have been completed or not
127: FOR cur_operation_record IN (select prior_operation from wip_operation_networks where
128: wip_entity_id = p_wip_entity_id and
129: next_operation = p_operation_sequence_number and
130: organization_id = p_organization_id) LOOP
131:

Line 981: FROM wip_operation_networks

977: ,attribute12
978: ,attribute13
979: ,attribute14
980: ,attribute15
981: FROM wip_operation_networks
982: WHERE wip_entity_id = p_wip_entity_id
983: AND next_operation = p_old_op_seq_num;
984:
985: -- cursor to copy new op --> xxx

Line 1014: FROM wip_operation_networks

1010: ,attribute12
1011: ,attribute13
1012: ,attribute14
1013: ,attribute15
1014: FROM wip_operation_networks
1015: WHERE wip_entity_id = p_wip_entity_id
1016: AND prior_operation = p_old_op_seq_num;
1017:
1018:

Line 1071: INSERT INTO wip_operation_networks

1067: nxtOpCurVar.created_by := FND_GLOBAL.user_id;
1068: nxtOpCurVar.last_update_date := sysdate;
1069: nxtOpCurVar.creation_date := sysdate;
1070:
1071: INSERT INTO wip_operation_networks
1072: ( prior_operation
1073: ,next_operation
1074: ,wip_entity_id
1075: ,organization_id

Line 1176: INSERT INTO wip_operation_networks

1172: prvOpCurVar.Last_Update_Date := sysdate;
1173: prvOpCurVar.Creation_Date := sysdate;
1174:
1175:
1176: INSERT INTO wip_operation_networks
1177: ( prior_operation
1178: ,next_operation
1179: ,wip_entity_id
1180: ,organization_id

Line 4399: from (select * from wip_operation_networks

4395: select count(1) into l_loop_available
4396: from dual
4397: where
4398: p_from_operation in (select next_operation
4399: from (select * from wip_operation_networks
4400: where next_operation <> p_to_operation and
4401: wip_entity_id = p_wip_entity_id)
4402: start with prior_operation = p_to_operation
4403: connect by prior_operation = prior next_operation) ;

Line 4939: from wip_operation_networks

4935: l_operation_seq_num := p_operation_seq_num;
4936:
4937: select count(*)
4938: into l_count_routing
4939: from wip_operation_networks
4940: where wip_entity_id = l_wip_entity_id and ( prior_operation = p_operation_seq_num or next_operation = p_operation_seq_num);
4941:
4942: select count(*)
4943: into l_count_mat