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_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 316: FROM BOM_OPERATION_SEQUENCES

312: SELECT 1
313: FROM BOM_OPERATION_NETWORKS
314: WHERE FROM_OP_SEQ_ID IN
315: (SELECT OPERATION_SEQUENCE_ID
316: FROM BOM_OPERATION_SEQUENCES
317: WHERE ROUTING_SEQUENCE_ID = p_rtg_seq_id
318: )
319: AND rownum=1
320: UNION ALL

Line 325: FROM BOM_OPERATION_SEQUENCES

321: SELECT 1
322: FROM BOM_OPERATION_NETWORKS
323: WHERE TO_OP_SEQ_ID IN
324: (SELECT OPERATION_SEQUENCE_ID
325: FROM BOM_OPERATION_SEQUENCES
326: WHERE ROUTING_SEQUENCE_ID = p_rtg_seq_id
327: )
328: AND rownum=1;
329:

Line 481: bom_operation_sequences bos

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

Line 497: bom_operation_sequences bos,

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

Line 525: FROM BOM_OPERATION_SEQUENCES

521: SELECT 1
522: FROM BOM_OPERATION_NETWORKS
523: WHERE FROM_OP_SEQ_ID IN
524: (SELECT OPERATION_SEQUENCE_ID
525: FROM BOM_OPERATION_SEQUENCES
526: WHERE ROUTING_SEQUENCE_ID = p_rtg_seq_id
527: )
528: AND rownum=1
529: UNION ALL

Line 534: FROM BOM_OPERATION_SEQUENCES

530: SELECT 1
531: FROM BOM_OPERATION_NETWORKS
532: WHERE TO_OP_SEQ_ID IN
533: (SELECT OPERATION_SEQUENCE_ID
534: FROM BOM_OPERATION_SEQUENCES
535: WHERE ROUTING_SEQUENCE_ID = p_rtg_seq_id
536: )
537: AND rownum=1;
538:

Line 735: update bom_operation_sequences

731: IS
732: i NUMBER;
733: BEGIN
734: for i in 1..ntwk_op_tbl.COUNT loop
735: update bom_operation_sequences
736: set cumulative_yield = ntwk_op_tbl(i).cumulative_yield,
737: reverse_cumulative_yield = ntwk_op_tbl(i).rev_cumulative_yield,
738: net_planning_percent = ntwk_op_tbl(i).net_planning_pct
739: where operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;

Line 744: update bom_operation_sequences

740:
741: -- Update child events based on the parameter
742: if p_update_events = 1 then
743: if p_operation_type = 2 then
744: update bom_operation_sequences
745: set cumulative_yield = ntwk_op_tbl(i).cumulative_yield,
746: reverse_cumulative_yield = ntwk_op_tbl(i).rev_cumulative_yield,
747: net_planning_percent = ntwk_op_tbl(i).net_planning_pct
748: where routing_sequence_id = p_routing_sequence_id

Line 751: update bom_operation_sequences

747: net_planning_percent = ntwk_op_tbl(i).net_planning_pct
748: where routing_sequence_id = p_routing_sequence_id
749: and process_op_seq_id = ntwk_op_tbl(i).operation_seq_id;
750: elsif p_operation_type = 3 then
751: update bom_operation_sequences
752: set cumulative_yield = ntwk_op_tbl(i).cumulative_yield,
753: reverse_cumulative_yield = ntwk_op_tbl(i).rev_cumulative_yield,
754: net_planning_percent = ntwk_op_tbl(i).net_planning_pct
755: where routing_sequence_id = p_routing_sequence_id

Line 1180: from bom_operation_sequences

1176: FOR i in REVERSE 1..ntwk_op_tbl.COUNT LOOP
1177: if i = ntwk_op_tbl.COUNT then/*
1178: select nvl(yield, 1)
1179: into l_yield
1180: from bom_operation_sequences
1181: where operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;*/
1182: -- BUG 4506235
1183: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1184: into l_yield

Line 1185: from bom_operational_routings bor, bom_operation_sequences bos

1181: where operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;*/
1182: -- BUG 4506235
1183: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1184: into l_yield
1185: from bom_operational_routings bor, bom_operation_sequences bos
1186: where bor.routing_sequence_id = bos.routing_sequence_id
1187: and bos.operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;
1188: ntwk_op_tbl(i).rev_cumulative_yield := l_yield;
1189: else

Line 1506: from bom_operation_sequences

1502: FOR i in REVERSE 1..ntwk_op_tbl.COUNT LOOP
1503: if i = ntwk_op_tbl.COUNT then/*
1504: select nvl(yield, 1)
1505: into l_yield
1506: from bom_operation_sequences
1507: where operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;*/
1508: -- BUG 4506235
1509: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1510: into l_yield

Line 1511: from bom_operational_routings bor, bom_operation_sequences bos

1507: where operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;*/
1508: -- BUG 4506235
1509: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1510: into l_yield
1511: from bom_operational_routings bor, bom_operation_sequences bos
1512: where bor.routing_sequence_id = bos.routing_sequence_id
1513: and bos.operation_sequence_id = ntwk_op_tbl(i).operation_seq_id;
1514: ntwk_op_tbl(i).rev_cumulative_yield := l_yield;
1515: else

Line 1666: from bom_operation_sequences

1662: BEGIN
1663: /*
1664: select nvl(yield, 1)
1665: into l_yield
1666: from bom_operation_sequences
1667: where operation_sequence_id = ntwk_op_tbl(op_ptr).operation_seq_id;*/
1668: -- BUG 4506235
1669: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1670: into l_yield

Line 1671: from bom_operational_routings bor, bom_operation_sequences bos

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

Line 1711: from bom_operation_sequences

1707:
1708: BEGIN/*
1709: select nvl(yield, 1)
1710: into l_yield
1711: from bom_operation_sequences
1712: where operation_sequence_id = ntwk_op_tbl(op_ptr).operation_seq_id;*/
1713: -- BUG 4506235
1714: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1715: into l_yield

Line 1716: from bom_operational_routings bor, bom_operation_sequences bos

1712: where operation_sequence_id = ntwk_op_tbl(op_ptr).operation_seq_id;*/
1713: -- BUG 4506235
1714: select DECODE(bor.cfm_routing_flag, 3, (DECODE(bos.operation_yield_enabled, 1, NVL(bos.yield, 1), 1)), NVL(bos.yield, 1))
1715: into l_yield
1716: from bom_operational_routings bor, bom_operation_sequences bos
1717: where bor.routing_sequence_id = bos.routing_sequence_id
1718: and bos.operation_sequence_id = ntwk_op_tbl(op_ptr).operation_seq_id;
1719:
1720: FOR next_opns_rec IN next_opns_cur(ntwk_op_tbl(op_ptr).operation_seq_id) LOOP