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.

[Home] [Help]

APPS.BOM_CALC_CYNP dependencies on BOM_OPERATION_SEQUENCES

Line 266: bom_operation_sequences bos

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
270: AND bonv.from_op_seq_id = bos.operation_sequence_id

Line 282: bom_operation_sequences bos,

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

Line 312: ( SELECT operation_sequence_id FROM bom_operation_sequences

308:
309: CURSOR check_nwk_exists_cur( p_rtg_seq_id NUMBER ) IS -- BUG 4348554
310: SELECT COUNT(*) FROM bom_operation_networks
311: WHERE from_op_seq_id IN
312: ( SELECT operation_sequence_id FROM bom_operation_sequences
313: WHERE routing_sequence_id = p_rtg_seq_id )
314: OR to_op_SEQ_ID IN
315: ( SELECT operation_sequence_id FROM bom_operation_sequences
316: WHERE routing_sequence_id = p_rtg_seq_id );

Line 315: ( SELECT operation_sequence_id FROM bom_operation_sequences

311: WHERE from_op_seq_id IN
312: ( SELECT operation_sequence_id FROM bom_operation_sequences
313: WHERE routing_sequence_id = p_rtg_seq_id )
314: OR to_op_SEQ_ID IN
315: ( SELECT operation_sequence_id FROM bom_operation_sequences
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)

Line 469: bom_operation_sequences bos

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
473: AND bonv.from_op_seq_id = bos.operation_sequence_id

Line 485: bom_operation_sequences bos,

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

Line 509: ( SELECT operation_sequence_id FROM bom_operation_sequences

505:
506: CURSOR check_nwk_exists_cur( p_rtg_seq_id NUMBER ) IS -- BUG 4348554
507: SELECT COUNT(*) FROM bom_operation_networks
508: WHERE from_op_seq_id IN
509: ( SELECT operation_sequence_id FROM bom_operation_sequences
510: WHERE routing_sequence_id = p_rtg_seq_id )
511: OR to_op_SEQ_ID IN
512: ( SELECT operation_sequence_id FROM bom_operation_sequences
513: WHERE routing_sequence_id = p_rtg_seq_id );

Line 512: ( SELECT operation_sequence_id FROM bom_operation_sequences

508: WHERE from_op_seq_id IN
509: ( SELECT operation_sequence_id FROM bom_operation_sequences
510: WHERE routing_sequence_id = p_rtg_seq_id )
511: OR to_op_SEQ_ID IN
512: ( SELECT operation_sequence_id FROM bom_operation_sequences
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)

Line 701: update bom_operation_sequences

697: IS
698: i NUMBER;
699: BEGIN
700: for i in 1..ntwk_op_tbl.COUNT loop
701: update bom_operation_sequences
702: set cumulative_yield = ntwk_op_tbl(i).cumulative_yield,
703: reverse_cumulative_yield = ntwk_op_tbl(i).rev_cumulative_yield,
704: net_planning_percent = ntwk_op_tbl(i).net_planning_pct
705: where operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;

Line 710: update bom_operation_sequences

706:
707: -- Update child events based on the parameter
708: if p_update_events = 1 then
709: if p_operation_type = 2 then
710: update bom_operation_sequences
711: set cumulative_yield = ntwk_op_tbl(i).cumulative_yield,
712: reverse_cumulative_yield = ntwk_op_tbl(i).rev_cumulative_yield,
713: net_planning_percent = ntwk_op_tbl(i).net_planning_pct
714: where routing_sequence_id = p_routing_sequence_id

Line 717: update bom_operation_sequences

713: net_planning_percent = ntwk_op_tbl(i).net_planning_pct
714: where routing_sequence_id = p_routing_sequence_id
715: and process_op_seq_id = ntwk_op_tbl(i).operation_seq_id;
716: elsif p_operation_type = 3 then
717: update bom_operation_sequences
718: set cumulative_yield = ntwk_op_tbl(i).cumulative_yield,
719: reverse_cumulative_yield = ntwk_op_tbl(i).rev_cumulative_yield,
720: net_planning_percent = ntwk_op_tbl(i).net_planning_pct
721: where routing_sequence_id = p_routing_sequence_id

Line 1133: from bom_operation_sequences

1129: FOR i in REVERSE 1..ntwk_op_tbl.COUNT LOOP
1130: if i = ntwk_op_tbl.COUNT then/*
1131: select nvl(yield, 1)
1132: into l_yield
1133: from bom_operation_sequences
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

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 1459: from bom_operation_sequences

1455: FOR i in REVERSE 1..ntwk_op_tbl.COUNT LOOP
1456: if i = ntwk_op_tbl.COUNT then/*
1457: select nvl(yield, 1)
1458: into l_yield
1459: from bom_operation_sequences
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

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 1619: from bom_operation_sequences

1615: BEGIN
1616: /*
1617: select nvl(yield, 1)
1618: into l_yield
1619: from bom_operation_sequences
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

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 1664: from bom_operation_sequences

1660:
1661: BEGIN/*
1662: select nvl(yield, 1)
1663: into l_yield
1664: from bom_operation_sequences
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

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