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_OPERATIONAL_ROUTINGS

Line 283: bom_operational_routings_v borv

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
286: AND bonv.operation_type = p_operation_type
287: AND bonv.transition_type <> 3

Line 305: FROM BOM_OPERATIONAL_ROUTINGS bor

301: AND bonv.transition_type <> 3 );
302: /****
303: CURSOR set_cfm_cur IS
304: SELECT cfm_routing_flag
305: FROM BOM_OPERATIONAL_ROUTINGS bor
306: WHERE bor.routing_sequence_id = p_routing_sequence_id;
307: ****/
308:
309: CURSOR check_nwk_exists_cur( p_rtg_seq_id NUMBER ) IS -- BUG 4348554

Line 320: FROM bom_operational_routings

316: WHERE routing_sequence_id = p_rtg_seq_id );
317:
318: CURSOR get_cfm_flag_cur( p_rtg_seq_id NUMBER ) IS -- BUG 4348554
319: SELECT nvl(cfm_routing_flag, 2)
320: FROM bom_operational_routings
321: WHERE routing_sequence_id = p_rtg_seq_id;
322:
323: i NUMBER;
324: l_yield NUMBER;

Line 486: bom_operational_routings_v borv

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
489: AND bonv.operation_type = p_operation_type
490: AND bonv.transition_type <> 3

Line 517: FROM bom_operational_routings

513: WHERE routing_sequence_id = p_rtg_seq_id );
514:
515: CURSOR get_cfm_flag_cur( p_rtg_seq_id NUMBER ) IS -- BUG 4348554
516: SELECT nvl(cfm_routing_flag, 2)
517: FROM bom_operational_routings
518: WHERE routing_sequence_id = p_rtg_seq_id;
519:
520:
521: /****

Line 524: FROM BOM_OPERATIONAL_ROUTINGS bor

520:
521: /****
522: CURSOR set_cfm_cur IS
523: SELECT cfm_routing_flag
524: FROM BOM_OPERATIONAL_ROUTINGS bor
525: WHERE bor.routing_sequence_id = p_routing_sequence_id;
526: ****/
527: i NUMBER;
528: l_yield NUMBER;

Line 1138: from bom_operational_routings bor, bom_operation_sequences bos

1134: where operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;*/
1135: -- BUG 4506235
1136: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1137: into l_yield
1138: from bom_operational_routings bor, bom_operation_sequences bos
1139: where bor.routing_sequence_id = bos.routing_sequence_id
1140: and bos.operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;
1141: ntwk_op_tbl(i).rev_cumulative_yield := l_yield;
1142: else

Line 1464: from bom_operational_routings bor, bom_operation_sequences bos

1460: where operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;*/
1461: -- BUG 4506235
1462: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1463: into l_yield
1464: from bom_operational_routings bor, bom_operation_sequences bos
1465: where bor.routing_sequence_id = bos.routing_sequence_id
1466: and bos.operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;
1467: ntwk_op_tbl(i).rev_cumulative_yield := l_yield;
1468: else

Line 1624: from bom_operational_routings bor, bom_operation_sequences bos

1620: where operation_sequence_id = ntwk_op_tbl(op_ptr).operation_seq_id;*/
1621: -- BUG 4506235
1622: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1623: into l_yield
1624: from bom_operational_routings bor, bom_operation_sequences bos
1625: where bor.routing_sequence_id = bos.routing_sequence_id
1626: and bos.operation_sequence_id = ntwk_op_tbl(op_ptr).operation_seq_id;
1627:
1628: FOR prev_opns_rec IN prev_opns_cur(ntwk_op_tbl(op_ptr).operation_seq_id) LOOP

Line 1669: from bom_operational_routings bor, bom_operation_sequences bos

1665: where operation_sequence_id = ntwk_op_tbl(op_ptr).operation_seq_id;*/
1666: -- BUG 4506235
1667: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1668: into l_yield
1669: from bom_operational_routings bor, bom_operation_sequences bos
1670: where bor.routing_sequence_id = bos.routing_sequence_id
1671: and bos.operation_sequence_id = ntwk_op_tbl(op_ptr).operation_seq_id;
1672:
1673: FOR next_opns_rec IN next_opns_cur(ntwk_op_tbl(op_ptr).operation_seq_id) LOOP