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 468: FROM bom_operation_networks_v bonv,

464: /* CURSOR start_ops_cur IS
465: SELECT DISTINCT from_op_seq_id start_op_seq_id,
466: from_seq_num start_op_seq_num,
467: nvl(yield, 1) start_op_yield
468: FROM bom_operation_networks_v bonv,
469: bom_operation_sequences bos
470: WHERE bonv.routing_sequence_id = p_routing_sequence_id
471: AND bonv.operation_type = p_operation_type
472: AND bonv.transition_type <> 3

Line 484: FROM bom_operation_networks_v bonv,

480: CURSOR start_ops_cur IS
481: SELECT DISTINCT from_op_seq_id start_op_seq_id,
482: from_seq_num start_op_seq_num,
483: DECODE(borv.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1)) start_op_yield
484: FROM bom_operation_networks_v bonv,
485: bom_operation_sequences bos,
486: bom_operational_routings_v borv
487: WHERE bonv.routing_sequence_id = borv.routing_Sequence_id
488: AND bonv.routing_sequence_id = p_routing_sequence_id

Line 501: ( SELECT null FROM bom_operation_networks_v bonv

497:
498: CURSOR check_nwk_links_cur IS
499: SELECT null FROM DUAL
500: WHERE exists
501: ( SELECT null FROM bom_operation_networks_v bonv
502: WHERE bonv.routing_sequence_id = p_routing_sequence_id
503: AND bonv.operation_type = p_operation_type
504: AND bonv.transition_type <> 3 );
505:

Line 798: FROM bom_operation_networks_v bonv

794: CURSOR next_ops_cur (cv_start_op_seq_id number) IS
795: SELECT to_op_seq_id next_op_seq_id,
796: to_seq_num next_op_seq_num,
797: transition_type
798: FROM bom_operation_networks_v bonv
799: WHERE routing_sequence_id = g_rtg_seq_id
800: AND from_op_seq_id = cv_start_op_seq_id
801: AND operation_type = g_op_type
802: -- AND transition_type <> 3

Line 868: FROM bom_operation_networks_v bonv

864:
865: PROCEDURE validate_operation(i NUMBER) is
866: CURSOR next_op_cur(cv_start_op_seq_id NUMBER) is
867: SELECT bonv.transition_type, bonv.planning_pct
868: FROM bom_operation_networks_v bonv
869: WHERE routing_sequence_id = g_rtg_seq_id
870: AND bonv.from_op_seq_id = cv_start_op_seq_id
871: AND bonv.operation_type = g_op_type
872: AND bonv.transition_type <> 3;

Line 906: FROM bom_operation_networks_v bonv

902: ) IS
903:
904: CURSOR end_op_cur IS
905: SELECT max(to_op_seq_id) end_op_seq_id
906: FROM bom_operation_networks_v bonv
907: WHERE bonv.routing_sequence_id = p_routing_sequence_id
908: AND bonv.operation_type = p_operation_type
909: AND bonv.transition_type <> 3
910: AND NOT EXISTS (SELECT NULL

Line 922: FROM bom_operation_networks_v bonv

918: CURSOR next_ops_cur (cv_start_op_seq_id number) IS
919: SELECT to_op_seq_id next_op_seq_id,
920: to_seq_num next_op_seq_num,
921: transition_type
922: FROM bom_operation_networks_v bonv
923: WHERE routing_sequence_id = p_routing_sequence_id
924: AND from_op_seq_id = cv_start_op_seq_id
925: AND operation_type = p_operation_type
926: AND transition_type <> 3

Line 933: FROM bom_operation_networks_v bonv

929: CURSOR next_alt_ops_cur (cv_op_seq_id number) IS
930: SELECT to_op_seq_id next_op_seq_id,
931: to_seq_num next_op_seq_num,
932: transition_type
933: FROM bom_operation_networks_v bonv
934: WHERE routing_sequence_id = p_routing_sequence_id
935: AND from_op_seq_id = cv_op_seq_id
936: AND operation_type = p_operation_type
937: AND transition_type = 2

Line 946: FROM bom_operation_networks_v bonv

942: CURSOR rework_ops_cur (cv_start_op_seq_id number) IS
943: SELECT to_op_seq_id, to_seq_num,
944: transition_type, nvl(planning_pct, 0) planning_pct,
945: from_op_seq_id, from_seq_num
946: FROM bom_operation_networks_v bonv
947: WHERE routing_sequence_id = p_routing_sequence_id
948: AND from_op_seq_id = cv_start_op_seq_id
949: AND operation_type = p_operation_type
950: AND transition_type = 3

Line 957: FROM bom_operation_networks_v bonv

953: CURSOR rework_ops_cur1 (cv_start_op_seq_id number) IS
954: SELECT to_op_seq_id, to_seq_num,
955: transition_type, nvl(planning_pct, 0) planning_pct,
956: from_op_seq_id, from_seq_num
957: FROM bom_operation_networks_v bonv
958: WHERE routing_sequence_id = p_routing_sequence_id
959: AND from_op_seq_id = cv_start_op_seq_id
960: AND operation_type = p_operation_type
961: AND transition_type = 3

Line 1185: FROM bom_operation_networks_v bonv

1181: ) RETURN NUMBER IS
1182:
1183: CURSOR end_op_cur IS
1184: SELECT max(to_op_seq_id) end_op_seq_id
1185: FROM bom_operation_networks_v bonv
1186: WHERE bonv.routing_sequence_id = p_routing_sequence_id
1187: AND bonv.operation_type = p_operation_type
1188: AND bonv.transition_type <> 3
1189: AND NOT EXISTS (SELECT NULL

Line 1201: FROM bom_operation_networks_v bonv

1197: CURSOR next_ops_cur (cv_start_op_seq_id number) IS
1198: SELECT to_op_seq_id next_op_seq_id,
1199: to_seq_num next_op_seq_num,
1200: transition_type
1201: FROM bom_operation_networks_v bonv
1202: WHERE routing_sequence_id = p_routing_sequence_id
1203: AND from_op_seq_id = cv_start_op_seq_id
1204: AND operation_type = p_operation_type
1205: AND transition_type <> 3

Line 1212: FROM bom_operation_networks_v bonv

1208: CURSOR next_alt_ops_cur (cv_op_seq_id number) IS
1209: SELECT to_op_seq_id next_op_seq_id,
1210: to_seq_num next_op_seq_num,
1211: transition_type
1212: FROM bom_operation_networks_v bonv
1213: WHERE routing_sequence_id = p_routing_sequence_id
1214: AND from_op_seq_id = cv_op_seq_id
1215: AND operation_type = p_operation_type
1216: AND transition_type = 2

Line 1225: FROM bom_operation_networks_v bonv

1221: CURSOR rework_ops_cur (cv_start_op_seq_id number) IS
1222: SELECT to_op_seq_id, to_seq_num,
1223: transition_type, nvl(planning_pct, 0) planning_pct,
1224: from_op_seq_id, from_seq_num
1225: FROM bom_operation_networks_v bonv
1226: WHERE routing_sequence_id = p_routing_sequence_id
1227: AND from_op_seq_id = cv_start_op_seq_id
1228: AND operation_type = p_operation_type
1229: AND transition_type = 3

Line 1235: FROM bom_operation_networks_v bonv

1231: CURSOR rework_ops_cur1 (cv_start_op_seq_id number) IS
1232: SELECT to_op_seq_id, to_seq_num,
1233: transition_type, nvl(planning_pct, 0) planning_pct,
1234: from_op_seq_id, from_seq_num
1235: FROM bom_operation_networks_v bonv
1236: WHERE routing_sequence_id = p_routing_sequence_id
1237: AND from_op_seq_id = cv_start_op_seq_id
1238: AND operation_type = p_operation_type
1239: AND transition_type = 3

Line 1547: --FROM bom_operation_networks_v

1543: ) IS
1544:
1545: CURSOR prev_links_cur (cv_to_seq_id number) IS
1546: SELECT from_op_seq_id prev_op, planning_pct
1547: --FROM bom_operation_networks_v
1548: FROM bom_operation_networks
1549: WHERE to_op_seq_id = cv_to_seq_id
1550: AND transition_type <> 3;
1551: