[Home] [Help]
1542: else
1543: begin
1544: select 1
1545: into l_temp
1546: from bom_operation_sequences
1547: where operation_sequence_id = l_wo_op_seq_id
1548: and routing_sequence_id = l_routing_seq_id;
1549:
1550: exception
1686: standard_operation_id
1687: INTO l_op_seq_id, -- CZH.I_OED-2: since select from BOS, replacement is already considered!
1688: l_dept_id,
1689: l_std_op_id
1690: FROM bom_operation_sequences
1691: WHERE operation_seq_num = p_to_op_seq_num
1692: AND routing_sequence_id = l_routing_seq_id
1693: -- BC: CZH.I_OED-1, use wdj.routing_revision_date instead of SYSDATE
1694: --and nvl(disable_date, sysdate+1) > sysdate
1863: -- BC: CZH.I_OED-2, should consider op replacement
1864: --select 1
1865: --into l_temp
1866: --from bom_operation_networks bon,
1867: -- bom_operation_sequences bos
1868: --where bon.from_op_seq_id = l_wo_op_seq_id
1869: --and bon.to_op_seq_id = l_op_seq_id
1870: --and bos.operation_sequence_id = l_op_seq_id
1871: --and nvl(bos.disable_date, l_rtg_revision_date) >= l_rtg_revision_date
1880: -- from_op_seq_id,
1881: -- l_rtg_revision_date) = l_wo_op_seq_id
1882: where from_op_seq_id IN (
1883: select bos.operation_sequence_id
1884: from bom_operation_sequences bos,
1885: bom_operation_sequences bos2
1886: where bos.operation_seq_num = bos2.operation_seq_num
1887: AND bos.routing_sequence_id = bos2.routing_sequence_id
1888: AND bos2.operation_sequence_id = l_wo_op_seq_id
1881: -- l_rtg_revision_date) = l_wo_op_seq_id
1882: where from_op_seq_id IN (
1883: select bos.operation_sequence_id
1884: from bom_operation_sequences bos,
1885: bom_operation_sequences bos2
1886: where bos.operation_seq_num = bos2.operation_seq_num
1887: AND bos.routing_sequence_id = bos2.routing_sequence_id
1888: AND bos2.operation_sequence_id = l_wo_op_seq_id
1889: )
1935: operation_sequence_id
1936: INTO l_jmp_std_op_id,
1937: l_jmp_dept_id,
1938: l_jmp_op_seq_id
1939: FROM bom_operation_sequences
1940: WHERE operation_seq_num = p_to_op_seq_num
1941: AND routing_sequence_id = l_routing_seq_id
1942: -- BC: CZH.I_OED-1, use wdj.routing_revision_date instead of SYSDATE
1943: --and nvl(disable_date, sysdate+1) >= sysdate
3602: /**********************************************
3603: BEGIN
3604: SELECT operation_seq_num
3605: INTO l_temp -- <> 0, if moving from the last op
3606: FROM bom_operation_sequences
3607: WHERE operation_seq_num = p_fm_op_seq_num
3608: AND operation_sequence_id = l_end_op_seq_id;
3609: EXCEPTION
3610: WHEN OTHERS THEN
3647: operation_seq_num
3648: INTO l_end_std_op_id,
3649: l_end_dept_id,
3650: l_end_op_seq_num
3651: FROM bom_operation_sequences
3652: WHERE operation_sequence_id = l_end_op_seq_id;
3653: END IF; --(g_aps_wps_profile='N')
3654:
3655: l_stmt_num := 342;
5182:
5183: BEGIN
5184: SELECT operation_seq_num
5185: INTO l_temp -- <> 0, if moving to the last op
5186: FROM bom_operation_sequences
5187: WHERE operation_seq_num = p_to_op_seq_num
5188: AND operation_sequence_id = l_end_op_seq_id;
5189: EXCEPTION
5190: WHEN OTHERS THEN
8156: l_stmt_num := 160;
8157:
8158: SELECT NVL(operation_sequence_id, -2)
8159: INTO l_to_op_seq_id
8160: FROM bom_operation_sequences
8161: WHERE operation_seq_num = l_to_op_seq_num
8162: AND routing_sequence_id = l_routing_seq_id
8163: /* BC: CZH.I_OED-1 compare against rtg_rev_date */
8164: AND nvl(disable_date, TO_DATE(l_rtg_revision_date, 'YYYY/MM/DD HH24:MI:SS')+1)
12160: reference_flag
12161: INTO l_bos_use_org_settings, l_bos_show_next_op_by_default,
12162: x_show_scrap_codes, l_bos_show_lot_attrib, l_bos_mul_res_usage_dates,
12163: l_bos_to_move_mandatory_flag, l_reference_flag
12164: FROM BOM_OPERATION_SEQUENCES BOS, WIP_OPERATIONS WO
12165: WHERE WO.wip_entity_id = p_wip_entity_id
12166: AND WO.operation_seq_num = p_operation_seq_num
12167: AND BOS.operation_sequence_id = WO.operation_sequence_id;
12168: ELSE
12845: **show_lot_attrib is not applicable for job operation page - always set it to 1**
12846: IF (p_routing_operation IS NOT NULL) THEN
12847: SELECT nvl(BOS.show_lot_attrib, 0)
12848: INTO x_show_lot_attrib
12849: FROM BOM_OPERATION_SEQUENCES BOS, WIP_OPERATIONS WO
12850: WHERE WO.wip_entity_id = p_wip_entity_id
12851: AND WO.operation_seq_num = p_operation_seq_num
12852: AND BOS.operation_sequence_id = WO.operation_sequence_id;
12853: ELSE