APPS.WSMPVLDT dependencies on BOM_STANDARD_OPERATIONS

Line 2934: bom_standard_operations bso

2930: SELECT bso.standard_operation_id
2931: INTO l_merge_std_op_id
2932: FROM wsm_starting_jobs_interface wsji,
2933: wip_operations wo,
2934: bom_standard_operations bso
2935: WHERE wsji.header_id = l_cur_wsji_rec.wsji_header_id
2936: --AND NVL(wsji.representative_flag, l_cur_wsji_rec.representative_flag) = 'Y'
2937: AND NVL(wsji.wip_entity_id, l_cur_wsji_rec.wip_entity_id) = wo.wip_entity_id
2938: AND wsji.operation_seq_num = wo.operation_seq_num

Line 5800: l_bso_stdop_code BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE default NULL; -- BBK NSOWLT

5796:
5797: l_op_seq_id NUMBER;
5798: l_bos_opseq_num NUMBER; -- BBK NSOWLT
5799: l_bos_stdop_id NUMBER; -- BBK NSOWLT
5800: l_bso_stdop_code BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE default NULL; -- BBK NSOWLT
5801: l_sj_intraoperation_step WSM_STARTING_JOBS_INTERFACE.INTRAOPERATION_STEP%TYPE default NULL; -- BBK NSOWLT
5802: l_rj_rout_seq_id NUMBER;
5803: l_end_op_seq_id NUMBER;
5804: x_error_code NUMBER;

Line 5997: From BOM_STANDARD_OPERATIONS

5993: If (l_bos_stdop_id <> -9999) Then --Fix for bug #2358941--
5994:
5995: l_stmt_num := 147;
5996: Select operation_code into l_bso_stdop_code
5997: From BOM_STANDARD_OPERATIONS
5998: Where standard_operation_id = l_bos_stdop_id;
5999:
6000: End If;
6001:

Line 7289: from bom_standard_operations

7285: if( l_start_std_op_id IS NULL) then
7286: l_stmt_num := 189;
7287: select standard_operation_id
7288: into l_start_std_op_id
7289: from bom_standard_operations
7290: where organization_id = l_organization_id -- BBK
7291: and operation_type = 1 -- Standard Operation Type BBK
7292: and line_id is NULL -- Not for a WIP Line BBK
7293: and operation_code = l_start_op_code;

Line 7444: FROM bom_standard_operations bso

7440: AND wrji.starting_std_op_id is not null
7441: AND wrji.starting_operation_code is not null
7442: AND wrji.starting_std_op_id <>
7443: ( SELECT bso.standard_operation_id
7444: FROM bom_standard_operations bso
7445: WHERE bso.organization_id = wrji.organization_id
7446: AND bso.operation_code = wrji.starting_operation_code);
7447:
7448: --VJ: End Changes for NSLBJ--

Line 7595: FROM bom_standard_operations

7591: IF (nvl(l_bos_std_op_id, -9999) <> -9999) THEN -- Get the op_code
7592: l_stmt_num := 200;
7593: SELECT operation_code
7594: INTO l_bso_op_code
7595: FROM bom_standard_operations
7596: WHERE standard_operation_id = l_bos_std_op_id
7597: AND organization_id = l_organization_id;
7598: END IF;
7599:

Line 7721: FROM bom_standard_operations bso,

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

Line 7756: FROM bom_standard_operations bso,

7752: bos.standard_operation_id -- 1685779 :added this col as part of select
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

Line 7910: From BOM_STANDARD_OPERATIONS

7906:
7907: If l_bos_std_op_id is not null Then
7908: l_stmt_num := 211;
7909: Select operation_code into l_bso_op_code
7910: From BOM_STANDARD_OPERATIONS
7911: Where standard_operation_id = l_bos_std_op_id;
7912:
7913: End If;
7914: