DBA Data[Home] [Help]

APPS.WSM_MES_UTILITIES_PVT dependencies on BOM_STANDARD_OPERATIONS

Line 135: from bom_standard_operations bso

131: into l_use_org_settings,
132: l_queue_mandatory,
133: l_run_mandatory,
134: l_to_move_mandatory
135: from bom_standard_operations bso
136: where standard_operation_id = p_standard_op_id;
137: exception
138: when others then
139: l_use_org_settings := 1; -- use org settings if bso had some problem

Line 545: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

541: AND BOS.operation_sequence_id = WO.operation_sequence_id;
542: ELSE
543: SELECT nvl(BSO.use_org_settings, 1), nvl(BSO.run_mandatory_flag, 0), nvl(BSO.to_move_mandatory_flag, 0)
544: INTO l_op_use_org_settings, l_op_run_mandatory_flag, l_op_to_move_mandatory_flag
545: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO
546: WHERE WO.wip_entity_id = p_wip_entity_id
547: AND WO.operation_seq_num = p_job_op_seq_num
548: AND BSO.standard_operation_id = WO.standard_operation_id
549: AND BSO.organization_id = WO.organization_id;