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.BOM_CALC_CYNP dependencies on BOM_OPERATION_NETWORKS_V

Line 265: FROM bom_operation_networks_v bonv,

261: /* CURSOR start_ops_cur IS
262: SELECT DISTINCT from_op_seq_id start_op_seq_id,
263: from_seq_num start_op_seq_num,
264: nvl(yield, 1) start_op_yield
265: FROM bom_operation_networks_v bonv,
266: bom_operation_sequences bos
267: WHERE bonv.routing_sequence_id = p_routing_sequence_id
268: AND bonv.operation_type = p_operation_type
269: AND bonv.transition_type <> 3

Line 281: FROM bom_operation_networks_v bonv,

277: CURSOR start_ops_cur IS
278: SELECT DISTINCT from_op_seq_id start_op_seq_id,
279: from_seq_num start_op_seq_num,
280: DECODE(borv.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1)) start_op_yield
281: FROM bom_operation_networks_v bonv,
282: bom_operation_sequences bos,
283: bom_operational_routings_v borv
284: WHERE bonv.routing_sequence_id = borv.routing_Sequence_id
285: AND bonv.routing_sequence_id = p_routing_sequence_id

Line 298: ( SELECT null FROM bom_operation_networks_v bonv

294:
295: CURSOR check_nwk_links_cur IS
296: SELECT null FROM DUAL
297: WHERE exists
298: ( SELECT null FROM bom_operation_networks_v bonv
299: WHERE bonv.routing_sequence_id = p_routing_sequence_id
300: AND bonv.operation_type = p_operation_type
301: AND bonv.transition_type <> 3 );
302: /****

Line 480: FROM bom_operation_networks_v bonv,

476: /* CURSOR start_ops_cur IS
477: SELECT DISTINCT from_op_seq_id start_op_seq_id,
478: from_seq_num start_op_seq_num,
479: nvl(yield, 1) start_op_yield
480: FROM bom_operation_networks_v bonv,
481: bom_operation_sequences bos
482: WHERE bonv.routing_sequence_id = p_routing_sequence_id
483: AND bonv.operation_type = p_operation_type
484: AND bonv.transition_type <> 3

Line 496: FROM bom_operation_networks_v bonv,

492: CURSOR start_ops_cur IS
493: SELECT DISTINCT from_op_seq_id start_op_seq_id,
494: from_seq_num start_op_seq_num,
495: DECODE(borv.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1)) start_op_yield
496: FROM bom_operation_networks_v bonv,
497: bom_operation_sequences bos,
498: bom_operational_routings_v borv
499: WHERE bonv.routing_sequence_id = borv.routing_Sequence_id
500: AND bonv.routing_sequence_id = p_routing_sequence_id

Line 513: ( SELECT null FROM bom_operation_networks_v bonv

509:
510: CURSOR check_nwk_links_cur IS
511: SELECT null FROM DUAL
512: WHERE exists
513: ( SELECT null FROM bom_operation_networks_v bonv
514: WHERE bonv.routing_sequence_id = p_routing_sequence_id
515: AND bonv.operation_type = p_operation_type
516: AND bonv.transition_type <> 3 );
517:

Line 832: FROM bom_operation_networks_v bonv

828: CURSOR next_ops_cur (cv_start_op_seq_id number) IS
829: SELECT to_op_seq_id next_op_seq_id,
830: to_seq_num next_op_seq_num,
831: transition_type
832: FROM bom_operation_networks_v bonv
833: WHERE routing_sequence_id = g_rtg_seq_id
834: AND from_op_seq_id = cv_start_op_seq_id
835: AND operation_type = g_op_type
836: -- AND transition_type <> 3

Line 902: FROM bom_operation_networks_v bonv

898:
899: PROCEDURE validate_operation(i NUMBER) is
900: CURSOR next_op_cur(cv_start_op_seq_id NUMBER) is
901: SELECT bonv.transition_type, bonv.planning_pct
902: FROM bom_operation_networks_v bonv
903: WHERE routing_sequence_id = g_rtg_seq_id
904: AND bonv.from_op_seq_id = cv_start_op_seq_id
905: AND bonv.operation_type = g_op_type
906: AND bonv.transition_type <> 3;

Line 940: FROM bom_operation_networks_v bonv

936: ) IS
937:
938: CURSOR end_op_cur IS
939: SELECT max(to_op_seq_id) end_op_seq_id
940: FROM bom_operation_networks_v bonv
941: WHERE bonv.routing_sequence_id = p_routing_sequence_id
942: AND bonv.operation_type = p_operation_type
943: AND bonv.transition_type <> 3
944: AND NOT EXISTS (SELECT NULL

Line 956: FROM bom_operation_networks_v bonv

952: CURSOR next_ops_cur (cv_start_op_seq_id number) IS
953: SELECT to_op_seq_id next_op_seq_id,
954: to_seq_num next_op_seq_num,
955: transition_type
956: FROM bom_operation_networks_v bonv
957: WHERE routing_sequence_id = p_routing_sequence_id
958: AND from_op_seq_id = cv_start_op_seq_id
959: AND operation_type = p_operation_type
960: AND transition_type <> 3

Line 967: FROM bom_operation_networks_v bonv

963: CURSOR next_alt_ops_cur (cv_op_seq_id number) IS
964: SELECT to_op_seq_id next_op_seq_id,
965: to_seq_num next_op_seq_num,
966: transition_type
967: FROM bom_operation_networks_v bonv
968: WHERE routing_sequence_id = p_routing_sequence_id
969: AND from_op_seq_id = cv_op_seq_id
970: AND operation_type = p_operation_type
971: AND transition_type = 2

Line 980: FROM bom_operation_networks_v bonv

976: CURSOR rework_ops_cur (cv_start_op_seq_id number) IS
977: SELECT to_op_seq_id, to_seq_num,
978: transition_type, nvl(planning_pct, 0) planning_pct,
979: from_op_seq_id, from_seq_num
980: FROM bom_operation_networks_v bonv
981: WHERE routing_sequence_id = p_routing_sequence_id
982: AND from_op_seq_id = cv_start_op_seq_id
983: AND operation_type = p_operation_type
984: AND transition_type = 3

Line 991: FROM bom_operation_networks_v bonv

987: CURSOR rework_ops_cur1 (cv_start_op_seq_id number) IS
988: SELECT to_op_seq_id, to_seq_num,
989: transition_type, nvl(planning_pct, 0) planning_pct,
990: from_op_seq_id, from_seq_num
991: FROM bom_operation_networks_v bonv
992: WHERE routing_sequence_id = p_routing_sequence_id
993: AND from_op_seq_id = cv_start_op_seq_id
994: AND operation_type = p_operation_type
995: AND transition_type = 3

Line 1232: FROM bom_operation_networks_v bonv

1228: ) RETURN NUMBER IS
1229:
1230: CURSOR end_op_cur IS
1231: SELECT max(to_op_seq_id) end_op_seq_id
1232: FROM bom_operation_networks_v bonv
1233: WHERE bonv.routing_sequence_id = p_routing_sequence_id
1234: AND bonv.operation_type = p_operation_type
1235: AND bonv.transition_type <> 3
1236: AND NOT EXISTS (SELECT NULL

Line 1248: FROM bom_operation_networks_v bonv

1244: CURSOR next_ops_cur (cv_start_op_seq_id number) IS
1245: SELECT to_op_seq_id next_op_seq_id,
1246: to_seq_num next_op_seq_num,
1247: transition_type
1248: FROM bom_operation_networks_v bonv
1249: WHERE routing_sequence_id = p_routing_sequence_id
1250: AND from_op_seq_id = cv_start_op_seq_id
1251: AND operation_type = p_operation_type
1252: AND transition_type <> 3

Line 1259: FROM bom_operation_networks_v bonv

1255: CURSOR next_alt_ops_cur (cv_op_seq_id number) IS
1256: SELECT to_op_seq_id next_op_seq_id,
1257: to_seq_num next_op_seq_num,
1258: transition_type
1259: FROM bom_operation_networks_v bonv
1260: WHERE routing_sequence_id = p_routing_sequence_id
1261: AND from_op_seq_id = cv_op_seq_id
1262: AND operation_type = p_operation_type
1263: AND transition_type = 2

Line 1272: FROM bom_operation_networks_v bonv

1268: CURSOR rework_ops_cur (cv_start_op_seq_id number) IS
1269: SELECT to_op_seq_id, to_seq_num,
1270: transition_type, nvl(planning_pct, 0) planning_pct,
1271: from_op_seq_id, from_seq_num
1272: FROM bom_operation_networks_v bonv
1273: WHERE routing_sequence_id = p_routing_sequence_id
1274: AND from_op_seq_id = cv_start_op_seq_id
1275: AND operation_type = p_operation_type
1276: AND transition_type = 3

Line 1282: FROM bom_operation_networks_v bonv

1278: CURSOR rework_ops_cur1 (cv_start_op_seq_id number) IS
1279: SELECT to_op_seq_id, to_seq_num,
1280: transition_type, nvl(planning_pct, 0) planning_pct,
1281: from_op_seq_id, from_seq_num
1282: FROM bom_operation_networks_v bonv
1283: WHERE routing_sequence_id = p_routing_sequence_id
1284: AND from_op_seq_id = cv_start_op_seq_id
1285: AND operation_type = p_operation_type
1286: AND transition_type = 3

Line 1594: --FROM bom_operation_networks_v

1590: ) IS
1591:
1592: CURSOR prev_links_cur (cv_to_seq_id number) IS
1593: SELECT from_op_seq_id prev_op, planning_pct
1594: --FROM bom_operation_networks_v
1595: FROM bom_operation_networks
1596: WHERE to_op_seq_id = cv_to_seq_id
1597: AND transition_type <> 3;
1598: