[Home] [Help]
5943: l_bos_opseq_num,
5944: l_bos_stdop_id,
5945: l_sj_intraoperation_step, -- BBK:NSO:WLT
5946: l_rj_rout_seq_id --VJ: Added for NSLBJ--
5947: FROM bom_operation_sequences bos,
5948: wsm_resulting_jobs_interface rj,
5949: wsm_starting_jobs_interface sj,
5950: wip_operations wo
5951: WHERE sj.header_id = l_header_id
7295:
7296: l_stmt_num := 190;
7297: select bos.operation_seq_num
7298: into l_start_op_seq_num
7299: from bom_operation_sequences bos
7300: where bos.routing_sequence_id = l_com_rtg_seq_id
7301: and bos.operation_type = 1
7302: and bos.STANDARD_OPERATION_ID = l_start_std_op_id;
7303: --BA: BUGFIX 2686319 get the start_op_seq_num
7583: select bos.operation_seq_num,
7584: bos.standard_operation_id
7585: into l_bos_op_seq_num,
7586: l_bos_std_op_id
7587: from bom_operation_sequences bos
7588: where bos.operation_sequence_id = l_start_op_seq_id;
7589:
7590: l_bso_op_code := NULL;
7591: IF (nvl(l_bos_std_op_id, -9999) <> -9999) THEN -- Get the op_code
7709:
7710: elsif (l_op_repeated_times <> 1 and l_start_op_seq_num is not null) then
7711:
7712: -- If the std oprn is repeated and operation seq num is populated,
7713: -- check if it is a valid op seq num in BOM operation sequences.
7714: -- If not, no-data-found is raised where we handle the error.
7715:
7716: l_stmt_num := 205;
7717: SELECT bos.operation_sequence_id,
7718: bos.standard_operation_id -- 1685779 :added this col as part of select
7719: INTO l_bos_op_seq_id,
7720: l_bos_std_op_id
7721: FROM bom_standard_operations bso,
7722: bom_operation_sequences bos,
7723: wsm_resulting_jobs_interface wrji
7724: WHERE wrji.header_id = l_header_id
7725: AND exists (SELECT null
7726: FROM wsm_split_merge_txn_interface txn
7753: INTO l_bos_op_seq_num,
7754: l_bos_op_seq_id,
7755: l_bos_std_op_id
7756: FROM bom_standard_operations bso,
7757: bom_operation_sequences bos,
7758: wsm_resulting_jobs_interface wrji
7759: WHERE wrji.header_id = l_header_id
7760: AND exists (SELECT null
7761: FROM wsm_split_merge_txn_interface txn
7885: SELECT bos.operation_sequence_id,
7886: bos.standard_operation_id
7887: INTO l_bos_op_seq_id,
7888: l_bos_std_op_id
7889: FROM bom_operation_sequences bos,
7890: wsm_resulting_jobs_interface wrji
7891: where wrji.header_id = l_header_id
7892: AND exists (SELECT null
7893: FROM wsm_split_merge_txn_interface txn
8080: AND nvl(wrji.starting_std_op_id, -9999) = nvl(l_bos_std_op_id, -9999)
8081: AND not exists
8082: ( select 'Is Primary Path'
8083: from bom_operation_networks bon,
8084: bom_operation_sequences bos
8085: where bon.transition_type = 1 -- Primary
8086: and nvl(bon.disable_date, sysdate+1) > sysdate
8087: --BC: CZH.I_OED-2
8088: --and bon.from_op_seq_id = bos.operation_sequence_id
8098: UNION
8099:
8100: select 'Is Primary Path'
8101: from bom_operation_networks bon,
8102: bom_operation_sequences bos
8103: --BC: CZH.I_OED-2
8104: --where bon.to_op_seq_id = bos.operation_sequence_id
8105: where WSMPUTIL.replacement_op_seq_id(
8106: bon.to_op_seq_id,
8111: and bos.operation_seq_num = wrji.starting_operation_seq_num
8112: -- BA NSO-WLT
8113: and bon.to_op_seq_id not in ( select bon1.from_op_seq_id
8114: from bom_operation_networks bon1,
8115: bom_operation_sequences bos1
8116: --BC: CZH.I_OED-2
8117: --where bon1.from_op_seq_id = bos1.operation_sequence_id
8118: where WSMPUTIL.replacement_op_seq_id (
8119: bon1.from_op_seq_id,
8583: l_stmt_num := 233;
8584:
8585: select unique WSMPUTIL.replacement_op_seq_id ( operation_sequence_id,l_rtg_rev_date)
8586: into l_osp_start_op_seq_id
8587: from bom_operation_sequences bos,
8588: wsm_resulting_jobs_interface wrji
8589: where wrji.header_id = l_header_id
8590: and wrji.rowid = l_wrji_rowid --SpUA add
8591: and bos.routing_sequence_id = wrji.common_routing_sequence_id