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: --Modified the cursor by replacing OR with UNION ALL for bug 12652195

Line 332: FROM bom_operational_routings

328: AND rownum=1;
329:
330: CURSOR get_cfm_flag_cur( p_rtg_seq_id NUMBER ) IS -- BUG 4348554
331: SELECT nvl(cfm_routing_flag, 2)
332: FROM bom_operational_routings
333: WHERE routing_sequence_id = p_rtg_seq_id;
334:
335: i NUMBER;
336: l_yield NUMBER;

Line 498: bom_operational_routings_v borv

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
502: AND bonv.transition_type <> 3

Line 541: FROM bom_operational_routings

537: AND rownum=1;
538:
539: CURSOR get_cfm_flag_cur( p_rtg_seq_id NUMBER ) IS -- BUG 4348554
540: SELECT nvl(cfm_routing_flag, 2)
541: FROM bom_operational_routings
542: WHERE routing_sequence_id = p_rtg_seq_id;
543:
544:
545: /****

Line 548: FROM BOM_OPERATIONAL_ROUTINGS bor

544:
545: /****
546: CURSOR set_cfm_cur IS
547: SELECT cfm_routing_flag
548: FROM BOM_OPERATIONAL_ROUTINGS bor
549: WHERE bor.routing_sequence_id = p_routing_sequence_id;
550: ****/
551: i NUMBER;
552: l_yield NUMBER;

Line 1155: FROM bom_operational_routings

1151:
1152: --bug 9676295 begin
1153:
1154: SELECT cfm_routing_flag into l_cfm_routing_flag
1155: FROM bom_operational_routings
1156: WHERE routing_sequence_id = p_routing_sequence_id;
1157:
1158: --check only for flow routings, not defaulting to 2 since for standard routing
1159: --this code will never be visited

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 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 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 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